No DSN is available for the sample sites when you set up Site Server 3.0 Commerce Edition (258145)

RESOLUTION

To resolve this issue, create at least one database and an associated system DSN. For instructions on how to do this using SQL Server 7.0, see the following information:

Note: The following instructions assume that you want to create a simple database and DSN primarily for the purpose of installing and viewing the sample sites. It is also assumed that both Site Server 3.0, Commerce Edition and SQL Server 7.0 are installed on the local computer running Windows 2000 Server.

Caution: If you plan to use the database and DSN in a production situation, set them up according to your specific needs, rather than using the following instructions.

Creating a database using SQL Server 7.0

1. Start the SQL Server 7.0 Enterprise Manager.
2. In the tree in the left-hand pane, double-click Microsoft SQL Servers, double-click SQL Server Group, and then double-click <computer name>.
3. Right-click Databases, and then click New Database.
4. Give the database a name, and then click OK (leave all the settings at their defaults) to create the database.

Creating a system DSN in Windows 2000

1. In Control Panel Administrative Tools, double-click Data Sources (ODBC).
2. In the ODBC Data Source Administrator dialog box, click the System DSN tab, and then click Add.
3. Select the SQL Server driver, and then click Finish.
4. In the Create a New Data Source to SQL Server dialog box, provide a name and description for the data source, and then select (local) for the server to connect to. Click Next.
5. When you are prompted to verify the authenticity of the login ID, select one of the following options:
   • If you are using Windows NT authentication, click With Windows NT authentication using the network login ID.
   • If you are using SQL Server authentication, follow these steps:
     1. Click With SQL Server authentication using a login ID and password entered by the user.
     2. In the Login ID box, type a valid login ID.
     3. In the Password box, type a valid password.
        
        Important By default, the sa account uses a blank password. You can help protect your systems by enforcing an sa password or by using Windows authentication.
6. Click Next.
7. Click the Change the default database to check box to enable it, and then select the name of the SQL Server database that you created previously. Click Next.
8. Leave all settings at their defaults, and then click Finish.
9. Click Test Data Source.
10. A message stating that all tests were completed successfully should be displayed. Click OK three times to close the dialog box.

Running Site Server 3.0, Commerce Edition

1. Run Site Server 3.0, Commerce Edition setup.
2. When you are prompted to select the DSN for the features (which includes the sample sites), click Select DSN, select the DSN you created previously, and then click OK.
3. If you are using SQL Server authentication, follow these steps:
   1. In the DB login ID box, type a valid login ID.
   2. In the Password box, type a valid password.
      
      Important By default, the sa account uses a blank password. You can help protect your systems by enforcing an sa password or by using Windows authentication.
   3. Click OK, and then click Next.