How to configure the SCM harweb JDBC driver so that it will connect to SQL Server using Windows authentication?

Document ID : KB000050538
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Please review the following information from Microsoft about JDBC driver usage with Windows authentication.

http://msdn.microsoft.com/en-us/library/ms378428

Solution:

The CA SCM r12 Implementation Guide, chapter 5, Installing the Web Interface, section How to prepare for the Web Interface Installation, talks about a known limitation of the SQL Server JDBC driver:

"If your DBMS is SQL Server, the Web Interface uses SQL Server authentication for its database connection, because the SQL Server JDBC driver supports SQL Server authentication only."

Though the above statement is still true for the out of box SQL Server JDBC driver, based on MSDN article MS378428 from Microsoft, it is possible to configure the JDBC driver to support not just SQL Server authentication but Windows authentication as well.

"The JDBC driver supports the use of Type 2 integrated authentication on Windows operating systems through the integratedSecurity connection string property. To use integrated authentication, copy the sqljdbc_auth.dll file to a directory on the Windows system path on the computer where the JDBC driver is installed."

Based on this information, the exact steps to configure the SCM Harweb JDBC driver to connect to SQL Server using Windows authentication is as below:

  1. copy the file sqljdbc_auth.dll to the following location on the harweb AP server machine in the JDBC installation directory:

    <installation directory>\sqljdbc_<version>\<language>\auth\

  2. Add the string integratedSecurity=true to the harweb.cfg file JDBC connection string: JDBCConnectionURL= jdbc:sqlserver://[servername ];instanceName=[instancename];databaseName=[ databasename];forwardReadOnlyMethod=serverCursor;integratedSecurity=true

  3. If the harweb AP server is running as a Windows service, please also check the Windows account used to start up the service.

For any other questions please review the Microsoft MSDN article as well as the SCM Implementation Guide.