Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Installing the Siebel Server >

Verifying the ODBC Data Source for MS SQL Server

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

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

To verify the ODBC data source for MS SQL Server

1. Navigate to Start > Programs > Administrative Tools > Data Sources (ODBC).
2. On the ODBC Data Source Administrator screen, select System DSN.
3. Record the name of the ODBC data source in Deployment Planning Worksheet if you have not already done so.

   You will need this information when you are installing the Siebel Database Server.

4. Select the data source SiebSrvr_EnterpriseName, where EnterpriseName is the name you gave the Siebel Enterprise during its configuration, and click Configure.

   The Microsoft SQL Server DSN Configuration screen appears.

5. Click Next, then click Client Configuration.

   The Edit Network Library Configuration screen appears.

6. Verify that the port number for the database is correct. If it is not, 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.

7. 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 to this effect.
   • If the connection could not be made, see Verifying Network Connectivity for the Siebel Server Machine and Troubleshooting the ODBC Data Source Connection.