Customers can use Windows Integrated Authentication (also known as NTLM Authentication, Domain Authentication and so on: to run queries against an MS SQL Server via JDBC using a MID Server running on a Windows host.

Problem Symptoms

Some customers have seen the following error:

MID Server reported error: java.sql.SQLException: This driver is not configured for integrated authentication. ClientConnectionId:f5905e6e-13c1-48da-85ef-fe1bd7e0a57d$000($LogonCommand.doExecute(
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$ Source) Source)


Step 1: Verify the SNC_JVM_ARCH Variable is Correct

Ensure the in the \agent\conf\wrapper-jvm.conf file exists in the MID Server installation directory and that it contains either of the following lines (use x86-64 for a 64-bit MID Server installation, x86-32 for a 32-bit MID Server):


Important: This variable needs to be set to the architecture (x86-32 for 32-bit; or x86-64 for 64-bit) of the Mid Server, not the host OS. It's possible for a 32-bit MID server to be installed and working on a 64-bit host OS. If you don't know whether your MID server was installed from the 32-bit or 64-bit MID Server installer do the following to check:

  • Go to the folder where the MID Server is installed, go into the logs directory
  • Open the latest agent... log file
  • Search in the log file for the string AutoUpgrade.3600 Installed
  • You'll see something like this, note the part right at the end that indicates whether the installed MID server is x86-32 or x86-64:
    2019-11-20 22:01:13 (530) AutoUpgrade.3600 Installed: [,]
    Example for 64-bit:11/12/19 05:03:00 (719) AutoUpgrade.3600 Installed: [,]

Step 2: Verify the Java Classpath and Library Path Variables are Correct

If the above doesn't resolve the issue try these steps:

  • In \agent\conf\wrapper-override.conf or wrapper.conf (preferred wrapper-override.conf) file in the MID Server installation directory make sure that you have

    # Java Classpath (include wrapper.jar)
    # Add class path elements as needed starting from 1*.jar*.jar

    # Java Library Path (location of Wrapper.DLL or
  • Make sure that you have the correct version (32 or 64bit) of sqljdbc_auth.dll in the folder lib/x86-32 and lib/x86-64
  • Make sure that you restart the mid server after any config change
  • Verify that the SQL server is configured to allow Integrated Authentication (
  • Check the driver compatibility (

Step 3: Contacting Support

If the issue still hasn't been resolved please raise a Case in HI with Customer Support, provide the results of the above troubleshooting steps and the following details:

a) MID server OS
b) JRE version
c) JDBC driver jar file and version
d) Full path of all occurrence of sqljdbc_auth.dll and their version info
e) Extract of MID server log and wrapper log where the error happened.

Article Information

Last Updated:2019-11-20 18:38:40