Verifying the ODBC Data Source for Microsoft SQL Server

This task is part of Verifying the ODBC Data Source.

Configuring the Siebel Enterprise automatically creates an ODBC system data source name (DSN) that the Siebel Server uses to connect to the Siebel database on the RDBMS.

Make sure that the appropriate database client has been installed and that the Siebel Server service is started prior to verifying the ODBC data source. This topic applies also to virtual ODBC data sources in a clustered environment.

Caution: Do not change the default settings that are created automatically with the ODBC data source.

To verify the ODBC data source for Microsoft SQL Server

1. Start the Microsoft ODBC Administrator.

   Run the 32-bit version of the Microsoft ODBC Administrator, which is located here: C:\Windows\SysWOW64\odbcad32.exe.

   Note: You need the 32-bit version of the Microsoft ODBC Administrator because Siebel CRM uses 32-bit ODBC drivers and database clients only.

2. On the ODBC Data Source Administrator dialog box, select the System DSN tab.

3. Review the data source name; its default name is SiebelEnterpriseName_DSN.

   In the data source name, SiebelEnterpriseName is the name that you gave the Siebel Enterprise during its configuration.

4. Record the name of the ODBC data source in Siebel Deployment Planning Worksheet if you have not already done so.

5. Select the data source SiebelEnterpriseName_DSN, and click Configure.

   The Microsoft SQL Server DSN Configuration screen appears.

6. Click Next, and 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, then edit it, and then click OK.

   To edit the port number, you might have to first select and then deselect the check box Dynamically Determine Port.

   The Microsoft SQL Server DSN Configuration screen appears.

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

   The program tests the connection:

   • If the connection is valid, then you see a message box confirming the connection.

   • If the connection could not be made, then see Verifying Network Connectivity for the Siebel Server Computer and Troubleshooting the ODBC Data Source Connection.