Siebel Installation Guide for Microsoft Windows > Configuring Siebel Enterprise Server and Related Components > Verifying the ODBC Data Source >

Verifying the ODBC Data Source for MS SQL Server

This topic is part of Verifying the ODBC Data Source.

The Siebel Server installation program automatically creates an ODBC system data source name (DSN) that it uses to connect to the Siebel Database on the RDBMS.

Information in this topic applies also to virtual ODBC data sources in a clustered environment.

CAUTION:  Do not change the default settings created automatically with the ODBC data source.

For more information about the ODBC data source, see Planning RDBMS Installation and Configuration.

To verify the ODBC data source for MS SQL Server

1. Navigate to Control Panel, Administrative Tools, then Data Sources (ODBC).
2. On the ODBC Data Source Administrator dialog box, select the System DSN tab.
3. Review the data source name; its default name is EnterpriseName_DSN, where EnterpriseName is the name you gave the Siebel Enterprise during its configuration.
4. Record the name of the ODBC data source in Deployment Planning Worksheet if you have not already done so.
5. Select the data source EnterpriseName_DSN, and click Configure.

   The Microsoft SQL Server DSN Configuration screen appears.

6. Click Next, then click Client Configuration.

   The Edit Network Library Configuration screen appears.

7. Verify that the port number for the database is correct.
8. If the port number is incorrect, edit it (to do so, you may need to first select and then unselect the check box Dynamically determine port). To continue, click OK.

   The Microsoft SQL Server DSN Configuration screen appears.

9. Select verification with SQL Server using a valid database login ID and password you enter in the Login ID and Password fields, then click Next.

   The program tests the connection:

   • If the connection is valid, you will see a message box confirming the connection.
   • If the connection could not be made, see Verifying Network Connectivity for the Siebel Server Machine and Troubleshooting the ODBC Data Source Connection.