INFO Steps for configuring FrontPage versions of SalesCart PRO and SalesCart Standard on a Windows 2003 Server running in IIS6 mode.

Article # 5338

The information in this article applies to this particular SalesCart Product(s): 
STD, PRO, SQL


SYMPTOMS
This article explains the steps needed to configure FrontPage versions of SalesCart PRO & SalesCart Standard to run on a Windows 2003 server running in IIS6 mode. This article applies only to FrontPage versions of SalesCart. There are currently no known issues with SalesCart SQL. For Dreamweaver versions of SalesCart please see KB article #5347.

CAUSE
Running SalesCart on a Windows 2003 server in IIS6 process.

RESOLUTION

This procedure needs to be completed in the exact order specified below. Failure to complete the steps in the exact order specified below may result in errors.

Step 1: Set Up IIS to allow parent paths

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 (IIS) Manager
  2. Expand (click on the plus sign) SERVER_NAME (local machine) > Web Sites > Site Name.
  3. Right-click the Site Name and select Properties.
  4. Select the Home Directory tab.
  5. Select Configuration.
  6. Select the Options tab.
  7. Check the Enable Parent Paths checkbox.
  8. Select OK > OK.

Step 2: 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.

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

  1. On the ODBC MicroSoft Access Setup screen enter the Data Source Name and choose Select.

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

  1. Select OK.

  1. Select Options and uncheck the option called Exclusive. Click OK > OK.

Step 3: 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.

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

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

  1. Select OK.
  2. Highlight the modified SalesCart1 database connection and select Verify.
  3. Select Apply > OK

Step 4: 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.

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

  1. Select OK.

Step 5: 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. Uncheck ALL available check boxes in the FPDB Properties Screen.

  1. 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 Uncheck the following boxes:
  • Script Source Access
  • Read
  • Write
  • Directory Browsing
  • Index this resource

  1. Select OK.

Step 6: 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

SUMMARY
The following article explains the steps to configuring a FrontPage SalesCart PRO/Standard web site on a Windows 2003 Server running in IIS6 process. This article applies only to FrontPage versions of SalesCart. For Dreamweaver versions of SalesCart please see KB article #5347.

STATUS
Current as of 10/28/03.

REFERENCE
KB# 5316, 5208


Additional Query Words: IIS6,2003

Active/inactive: Active
Author:
 ew, wc
Date:
 09/22/03 updated 10/28/03