Installation Guide › WebLogic 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 Connector Xpress, or you can download it from Microsoft.

If you plan to use Connector Xpress, it must run on the same domain as the Microsoft SQL Server endpoint. Also, SQL Server must be configured to allow the user to access the appropriate database instances.

Follow these steps:

1. Update the CA IAM CS service to run as the required Windows user.

   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.
   2. Right-click CA IdentityMinder-Connector Server (Java), then click Properties.
   3. Select the Account check box, and then complete the details of the domain user under which you want to run the service.
2. Stop and restart the CA IAM CS service.
3. 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.