User with SQL database and Windows authentication have issues and get these errors:
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:d0b5c2fc-ed35-4360-84b9-53c70d5137b7
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3422)..
Caused by: java.lang.UnsatisfiedLinkError: no mssql-jdbc_auth-9.4.1.x64 in java.library.path
The Database plugin will need new drivers and DLL installed with the agent.
Release : 12.0
Component : Workload Automation Database Agent
OS: Windows only
Download the latest JDBC driver from Microsoft. Extract the jar file from the zip.
It will have this naming format:
mssql-jdbc-9.x.x.jre8 (e.g mssql-jdbc-9.4.1.jre8)
Copy the jar to <agent install directory/jars/ext>
E.g "C:\Program Files\CA\WA Agent\jars\ext"
Remove any existing sqlJDBC jar files (move it out of agent directory, don't rename).
Next, copy the auth DLL from JDBC package downloaded from Microsoft. It will be under: "sqljdbc_9.4/enu/auth/x64"
The DLL naming format is:
mssql-jdbc_auth-9.x.x.x64.dll, e.g. mssql-jdbc_auth-9.4.1.x64.dll
Copy that DLL to "<agent install directory"
E.g "C:\Program Files\CA\WA Agent"
Sample JDBC string for domain user:
jdbc:sqlserver://db_host:1433;databaseName=MyDB;integratedSecurity=true;