After upgrade to .47 I am getting and error: "This driver is not configured for integrated authentication."

Question

After upgrade to the .47 release I am getting an error in the qieLauncher log file:

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

What does this mean and what is the cause?

Answer 1

The Microsoft JDBC driver was upgraded from 7.0 to the 8.2.1 version in the .47 release. If you are using the integratedSecurity=true option with QIE then there is an additional dll required for the jdbc.

Here are the steps to fix this.

1. Download the mssql-jdbc_auth-8.2.1.x64.dll from "https://repo1.maven.org/maven2/com/microsoft/sqlserver/mssql-jdbc_auth/8.2.1.x64/"
2. Move that dll to the C:\Program Files\Java\jre1.8.0_???\bin directory
3. Using the qie service manager stop QIE and then Start QIE.

This will then start Java/QIE with that dll included and allow QIE to connect to the Database.

The error should indicate which version of MSSQL you want to use. The archive of JDBC Authentication DLL versions can be found here:
https://repo1.maven.org/maven2/com/microsoft/sqlserver/mssql-jdbc_auth/

Answer 2

You can also lock QIE to load a specific mssql jar by setting a preload lib directory.  This may prevent this particular issue now, but it can also create issues in the future by not updating the jars.  Use it with caution.

The archive of JDBC Driver versions can be found here:
https://repo1.maven.org/maven2/com/microsoft/sqlserver/mssql-jdbc/

You can override the mssql jar shipped with QIE by following these instructions:

https://www.qvera.com/kb/index.php/1528/how-do-load-my-version-of-library-before-qies-shipped-version?show=1528#q1528