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:
- Download a different version of
sqljdbc_auth.dll
and place it inruntime\lib\jdbc\mssql\auth[bit_version]
. - Copy the existing
sqljdbc_auth.dll
fromruntime\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.
Related articles