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
This driver is not configured for integrated authentication.02Likely causes
- With jTDS, the
ntlmauth.dllfile is missing from the JRE directory the agent uses at runtime. - With the MS JDBC driver, the
mssql-jdbc_authDLL is missing from the JRE directories the agent uses. - The connection string lacks the parameters required by the driver.
03How to fix it
- For jTDS, copy
ntlmauth.dllinto<JITTERBIT_HOME>/jre/bin, addintegratedSecurity=trueto Additional Connection String Parameters, and restart the agent service. - For the MS JDBC driver, copy the matching
mssql-jdbc_authx64 DLL into both<JITTERBIT_HOME>/jre/binand<JITTERBIT_HOME>/jre/lib, addintegratedSecurity=true;trustServerCertificate=true, and restart the agent service.
04Official documentation
→Related errors
- Base64 decoding failedThis Jitterbit error in DBLookup or DBExecute means an agent earlier than 12.9 tried to Base64-decode a JDBC result that only looks like Base64, such as a JWT. For private agents, upgrade to version 12.9 or later.
- Database connection could not be established due to a security policy violationThis Jitterbit error means agent 12.10 or later blocked a database connection to a loopback address or one that uses a restricted connection string parameter. On the private agent, configure the [JdbcSecurity] section of jitterbit.conf to allow the specific connection or parameter.
- Field value too long / values were truncatedThis Jitterbit database error means a mapped source value is longer than the target column, and by default the value is rejected. In the activity configuration, enable Allow truncation of character fields.
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