Jitterbit · Database connector (SQL Server JDBC)

This driver is not configured for integrated authentication

Short answer

This Jitterbit SQL Server error means the DLL that Windows integrated authentication needs is missing from the JRE directories the private agent uses. For jTDS, copy ntlmauth.dll into <JITTERBIT_HOME>/jre/bin, add integratedSecurity=true to Additional Connection String Parameters, and restart the agent service.

VerifiedLast verified

01Error text

Jitterbit error
This driver is not configured for integrated authentication.

02Likely causes

  • With jTDS, the ntlmauth.dll file is missing from the JRE directory the agent uses at runtime.
  • With the MS JDBC driver, the mssql-jdbc_auth DLL is missing from the JRE directories the agent uses.
  • The connection string lacks the parameters required by the driver.

03How to fix it

  1. For jTDS, copy ntlmauth.dll into <JITTERBIT_HOME>/jre/bin, add integratedSecurity=true to Additional Connection String Parameters, and restart the agent service.
  2. For the MS JDBC driver, copy the matching mssql-jdbc_auth x64 DLL into both <JITTERBIT_HOME>/jre/bin and <JITTERBIT_HOME>/jre/lib, add integratedSecurity=true;trustServerCertificate=true, and restart the agent service.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.