Siebel Security Guide > Security Adapter Authentication >

Implementing Database Authentication with MS SQL Server

This topic describes additional tasks you must perform when implementing database authentication if you are using Siebel Business Applications with an MS SQL Server database. For information on implementing database authentication, see Implementing Database Authentication.

When you install the Siebel Server, an ODBC data source name (DSN) is created, which the Siebel Server uses to connect to the Siebel database. If you implement database authentication, and you are using Siebel Business Applications with a Microsoft SQL Server database, then make sure that you select the correct ODBC DSN configuration settings; if you do not, Siebel Web Clients can log in to the Siebel application without providing a password.

When you configure the ODBC DSN settings for an MS SQL Server database, you can choose from the following authentication options:

• Windows NT authentication using the network login ID

  This option allows users to access applications on the server by entering a network login ID only. If you select this option, then Siebel Web Clients attempting to access the Siebel application are not required to enter a password.

• SQL Server authentication using a login ID and password entered by the user

  This option requires users attempting to access applications on the server to enter a valid user ID and password. Select this option to make sure that Siebel Web Clients must enter both a Siebel user ID and a password to access the Siebel application.

The following procedure describes how to set the MS SQL Server ODBC data source settings on your Siebel Server.

To set ODBC data source values for MS SQL Server

1. On the Siebel application server, from the Start menu, choose Settings, Control Panel, Administrative Tools, and then the Data Sources (ODBC) item.
2. On the ODBC Data Source Administrator dialog box, select the System DSN tab.
3. Select the Siebel data source name, and click Configure. The default Siebel data source name (DSN) is EnterpriseName_DSN, where EnterpriseName is the name you assigned the Siebel Enterprise when you configured it.

   The Microsoft SQL Server DSN Configuration screen appears.

4. You are presented with the following authentication options:
   • Windows NT authentication using the network login ID.

     Do not select this option.

   • SQL Server authentication using a login ID and password entered by the user.

     Select this option to make sure that Siebel Web Clients must enter both a Siebel user ID and a password to access the Siebel application.

5. Amend any other configuration options as required, then click Next.
6. Click Finish.