Windows 2003 Server

The Microsoft Windows 2003 server by default is the most secure operating system to date Microsoft has created. However, it is much more difficult to administer and operate because by default everything is turned off. Once your service provider has ASP and database connections running correctly, they will need to follow these additional procedures for SalesCart.

Step 1: Set Up Static DSN on the Web Server

Note: The following steps need to be performed on the web server by the server administrator:

1. Open ODBC Data Source Administrator. Start>>Programs>>Administrative Tools>>Data Sources (ODBC).
2. Select the System DSN tab.
3. Select Add.



4. On the Create New Data Source Wizard screen Select Microsoft Access Driver (*.mdb) and Select Finish.



5. On the ODBC Microsoft Access Setup screen enter the Data Source Name and choose Select.



6. On the Select Database screen, Browse to the absolute path of the shop.mdb database and highlight the shop.mdb database.



7. Select OK>>OK>>OK.

Step 2: Set SalesCart to use static DSN connection within FrontPage

Note: The following steps are performed by the SalesCart user within the FrontPage client.

1. In FrontPage, Open the SalesCart site on the remote web server.
2. Modify the database connection. Select Tools>>Web Settings>>Database tab.
3. Highlight the existing Salescart1 database connection and select Modify.



4. Select the 'System data source on web server' radio button and select Browse.



5. Select the data source created in Step 1 and select OK.



6. Select OK.
7. Highlight the modified SalesCart1 database connection and select Verify.
8. Select Apply>>OK

Step 3: Set Correct Database Permissions

Note: The following steps need to be performed on the web server by the server administrator:

1. Open Internet Information Services Manager. Start>>Programs>>Administrative Tools>>Internet Information Services Manager
2. Expand (click on the plus sign +) SERVER_NAME (local machine)>>Web Sites>> Site Name>>FPDB.
3. Right-click the /FPDB folder and select Permissions.



4. Select the Internet Guest Account (SERVERNAME\IUSR_SERVERNAME) user account and select Modify.



5. Select OK.

 

Step 4: Remove Anonymous browse access from the FPDB directory

Note: The orders database is not secured until this step has been completed! There are two methods to disable Browse access. Both methods are covered below.

Method 1: Performed by the SalesCart user

Note: Initially this step should be performed on both the local and remote (live) copies of the Salescart website.

1. In FrontPage, open the local copy of your SalesCart Website.
2. Right-click on the /FPDB folder and select Properties.
3. Un-check ALL available check boxes in the FPDB Properties Screen.



4. Select Apply>>OK.

Method 2: Performed by the server administrator

1. Open Internet Information Services Manager. Start>>Programs>>Administrative Tools>>Internet Information Services Manager
2. Expand (click on the plus sign +) SERVER_NAME (local machine)>>Web Sites>> Site Name>>FPDB.
3. Right-click the /FPDB folder and select Properties.
4. On the Directory tab Un-check the following boxes:
   o Script Source Access
   o Read
   o Write
   o Directory Browsing
   o Index this resource           



5. Select OK.

Step 5: Configure SalesCart to use CDOSYS to send merchant and customer emails

1. See the following Knowledge Base article: http://support.salescart.com/kb/KB-details.asp?key=5316