Connector Guides › Java Connector Server Implementation Guide › Installing Java CS › Manual Activation of JDBC Vendor Support › How to Activate Microsoft SQL Native Authentication on Windows

How to Activate Microsoft SQL Native Authentication on Windows

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

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

To activate Microsoft SQL Native Authentication on Windows, do the following:

1. Update the Java CS service to run as the required Windows user and restart the service.
2. By default the Java CS service is set to run as the local SYSTEM user, however if you are using trusted authentication you must run the service as a domain user. Do the following:
   1. Click Start, Control Panel, Administrative Tools, Services.

      The Services window appears.

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

      The Properties dialog appears.

   3. Select the This account check box, and then complete the details of the domain user under which you want to run the service.
3. Shutdown and restart the Java 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.