Installation Guide › WebSphere Version › Connector Server Installation › Set Up JDBC Support › Set Up Windows Authentication for the SQL Server Connector

Set Up Windows Authentication for the SQL Server Connector

Microsoft SQL Native Authentication on Windows can only be activated when both Connector Xpress and CA IAM CS are running on Windows operating systems. The required library sqljdbc_auth.dll is bundled with the CA IAM CS.

The user must run Connector Xpress on the same domain as the Microsoft SQL server. Also, the Microsoft SQL server must be configured to allow that user to access the appropriate database instances.

Follow these steps:

1. Update the CA IAM CS service to run as the required Windows user and restart the service.
2. By default the service is set to run as the local SYSTEM user. However, if you are using trusted authentication, run the service as a domain user. Perform these steps:
   1. Click Start, Control Panel, Administrative Tools, Services.

      The Services window appears.

   2. Right-click CA IdentityMinder-Java Connector Server, then click Properties.

      The Properties dialog appears.

   3. Select the Account check box, and then complete the details of the domain user under which you want to run the service.
3. Stop and restart the CA IAM CS service.
4. When you set up Microsoft SQL datasource in Connector Xpress, select the Native check box on the Edit Sources dialog.

   Connector Xpress adds the following to the JDBC URL used for the connection:

   integratedSecurity=true
   

   Note: For more information about configuring data sources, see the Connector Xpress Guide.