Microsoft KB Archive/258145

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

Article ID: 258145

Article Last Modified on 9/1/2006

-

APPLIES TO


 * Microsoft Windows 2000 Server
 * Microsoft Site Server 3.0 Commerce Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q258145



SYMPTOMS
During the setup of Site Server 3.0, Commerce Edition, you are prompted in the Microsoft Site Server 3.0, Commerce Edition Database Configuration dialog box to select a Data Source Name (DSN) for the sample sites. If you attempt to continue without selecting a DSN, the following error message occurs:

[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified



CAUSE
At least one database that is compatible with the sample sites, and an associated system DSN must be created before you install the sample sites.



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  .
 * 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
 In Control Panel Administrative Tools, double-click Data Sources (ODBC). In the ODBC Data Source Administrator dialog box, click the System DSN tab, and then click Add. Select the SQL Server driver, and then click Finish. 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. 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.</li> If you are using SQL Server authentication, follow these steps: <ol style="list-style-type: lower-alpha;"> Click With SQL Server authentication using a login ID and password entered by the user.</li> In the Login ID box, type a valid login ID.</li> 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.</li></ol> </li></ul> </li> Click Next.</li> 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.</li> Leave all settings at their defaults, and then click Finish.</li> Click Test Data Source.</li> A message stating that all tests were completed successfully should be displayed. Click OK three times to close the dialog box.</li></ol>

Running Site Server 3.0, Commerce Edition
<ol> Run Site Server 3.0, Commerce Edition setup.</li> 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.</li> If you are using SQL Server authentication, follow these steps: <ol style="list-style-type: lower-alpha;"> In the DB login ID box, type a valid login ID.</li> 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.</li> Click OK, and then click Next.</li></ol> </li></ol>

<div class="moreinformation_section">

MORE INFORMATION
The sample sites are as follows:

Ad ServerClocktowerVolcano CoffeeMicrosoft PressTrey ResearchMicrosoft Market

(c) Microsoft Corporation 2000, All Rights Reserved. Contributions by Kevin Zollman, Microsoft Corporation.

Additional query words: data source name set up install installation pw ss ssce akz

Keywords: kbpending kbprb KB258145

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.