Windows Authentication for SQL Server Connection

The Talend Studio expects a SQL Server user for connection details. An extra configuration step is required using the NTLMAuth library to use Windows Authentication (Active Directory).

For traditional SQL Server users, no additional configuration is required. However, to configure Windows Authentication, the latest jTDS must be downloaded and installed. jTDS is available at sourceforge.net (jtds-#-dist.zip).

After downloading the archive and extracting, copy the following:

64-bit Systems

Copy jtds-1.3.1-dist\x64\SSO\ntlmauth.dll to:

1. C:\Windows\System32
2. C:\Program Files\Java\jre*\bin

32-bit Systems

Copy jtds-1.3.1-dist\x64\SSO\ntlmauth.dll to:

1. C:\Windows\System32
2. C:\Program Files\Java\jre*\bin

Restart Talend Studio and remove the username and password for the connection:

Should this not suffice, append the parameter integratedSecurity=true to the JDBC string:

If the following error appears:

SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

Place the system-specific ntlmauth.dll into any other Java install folders (i.e. C:\Program Files (x86)).