How to connect Talend to SQL Server using integrated Security

The default setup of Talend doesn’t allow integrated security connections to SQL server. In order to connect to sql server with integrated security you must have ntlmauth.dll installed – it should be in your BIN and JRE\BIN folders e.g. c:\program files\Zulu\zulu-8\bin and c:\program files\Zulu\zulu-8\jre\bin. I also prefer to have a copy in windows\system32 just in case.

If that doesn’t work I also use -vm argument to ensure that the correct version of zulu\jre\bin is loaded e.g. – vm ” c:\program files\Zulu\zulu-8\jre\bin”

Then its just a matter of adding IntegratedSecurity=SSPI to your connection in the Additional parameters section of your Database connection .

oh and don’t forget to add your port if sql is running as an instance