Set up the System DSN on each test computer

  • Article

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2

To set up the System Data Source Name (DSN) on each test computer

  1. Open ODBC Data Source Administrator.

  2. Click the SystemDSN tab.

  3. Click Add.

  4. In the Create New Data Source wizard, click SQL Server, and then Finish.

  5. In the Create a New Data Source to SQL Server dialog box, fill in the Name and Description text boxes. In the Server box, type or select the name of the computer.

    Important

    • If you previously configured an ODBC data source for the same SQL server, a dialog box may appear which reads, "A new data source will be created with the following configuration." Click Finish if you do not want to change databases. Otherwise, follow steps 6 through 9.

  6. Click Next to accept the following default settings:

    • With Windows NT authentication using the network login ID.

    • Connect to SQL Server to obtain default settings for the additional configuration options.

  7. Click Next a second time to accept the following default settings:

    • Use ANSI quoted identifiers.

    • Use ANSI nulls, paddings and warnings.

      Important

The Change the default database to check box should be cleared. If, when setting up a user account, you selected a database other than master, you should now select the Change the default database to check box, and then click that database in the list.

  1. Click Finish to accept the default setting, Perform translation for character data.

  2. In the ODBC Microsoft SQL Server Setup dialog box, click Test Data Source, and verify that the "Tests completed successfully!" message appears.

Notes

  • Before you begin, confirm that your computer is connected to the domain, and that you are logged into the domain as a user. See Related Topics for more information.

  • To open Data Sources (ODBC), click Start, click Control Panel, double-click Administrative Tools, and then double-click Data Sources (ODBC).

Information about functional differences

  • Your server might function differently based on the version and edition of the operating system that is installed, your account permissions, and your menu settings. For more information, see Viewing Help on the Web.

See Also

Concepts

Set up a user account on a SQL server
Create and Configure Counter Logs