How do I configure integrated authentication for a Microsoft SQL Server connection in Talend Studio?

[TalendSolutionExpert]

Microsoft SQL Server supports NT LAN Manager (NTLM) or integrated authentication. In integrated authentication, the Windows service account is used to authenticate in SQL Server. Therefore, a username and password are not needed while defining the connection.

In Talend Studio, you can create a SQL Server metadata connection with integrated authentication.

Resolution

To create a SQL Server metadata connection with integrated authentication in Studio:

1. From the Microsoft Download Center page, download the JDBC driver package that contains the sqljdbc_auth.dll file to the machine hosting Talend Studio.
2. Move the sqljdbc_auth.dll file to the C:\Windows\System32 folder.
3. Launch Studio, then create a SQL Server metadata connection.

4. In the Additional parameters text box, enter integratedSecurity=true.

5. Enter the other valid connection properties as needed, then test the connection: