JDBC Authentication Error

Reported for version 9

Problem

Getting the following errors in DQC and DQD:

DQC - com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
WARNING: Failed to load the sqljdbc_auth.dll

or:

DQD - 2015-12-17 04:30:33 ERROR: Cannot connect to the database[STEP Policy main table[Jdbc Reader]]com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication

Solution

The error is caused by a missing or incompatible driver. To resolve the issue, try one of the following:

  1. Download a different version of sqljdbc_auth.dll and place it in runtime\lib\jdbc\mssql\auth[bit_version]. 
  2. Copy the existing sqljdbc_auth.dll from runtime\lib\jdbc\mssql\auth[bit_version] to the java library folder. Please notice, we provide 3 unique versions of this library, for x86, x86_64 and IA64 architecture, you will need to choose a version compatible to the Java you are running.