Setup Steps: Install Database Tables

Before any database tables can be loaded or configured you must have a running database server. For instructions on installing your database server see vendor documentation (i.e. Microsoft SQL Server or Oracle).

1. Create Two empty databases and name them after your storefront (i.e. MyStore and MyStoreCC).

  1. MyStore will be the primary SendSafe database
  2. MyStoreCC will be the secured database that holds only Credit Card information.

2. Setup an SYSTEM ODBC DSN for the "MyStore" database and name it DSN = MyStore.
see ODBC Database Connection  for instructions on how to create Microsoft ODBC DSN (connections).
You must setup an ODBC DSN on every computer that will be running SendSafe ASP or Robot code, this must include IIS Web Server computer and the computer running the SendSafe robot.

Make sure you use SQL Server authentication, not Windows NT authentication.

3. Setup an SYSTEM ODBC DSN for the "MyStoreCC" (credit card numbers) secure database and name it DSN = MyStoreCC.
see ODBC Database Connection  for instructions on how to create Microsoft ODBC DSN (connections). You need to setup an ODBC DSN for MyStoreCC only on the computer that will be running SendSafe Robot code. You should not setup an  ODBC DSN on any IIS Web Server unless the robot code (jsof.exe) is running on that IIS Web Server.

Make sure you use SQL Server authentication, not Windows NT authentication.

4. Setup database User Accounts for the SendSafe Robot (backend system):

  1. "JsofUser" for SendSafe Robot Full R/WAccess to the the "MyStore" database
  2. "JsofUserCC" for SendSafe Robot Full R/W Access to the "MyStoreCC" database.
    This database should never use the same account(s) that are used for access to the "MyStore" database.

5. Setup database User Accounts for ASP Page Access:

  1. "WebAdmin" Give this account R permission to the "MyStore" database.
  2. "WebAdmin" Give this account INSERT/UPDATE permission to the "MyStore" database tables: EventLog and LogonToken (this is very important). If this is not done then the Admin Pages will not work. 
  3. "UserPub" Give this account "MyStore" R/W permission to the "MyStore" database.