0

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).

Talend SQL Server Active Directory  01

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:

Talend SQL Server Active Directory 02

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

Talend SQL Server Active Directory 03

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)).

Norbert Krupa

Technical Consultant

Leave a Reply

Your email address will not be published. Required fields are marked *