https://community.qlik.com/t5/Official-Support-Articles/How-do-I-configure-integrated-authentication-for-a-Microsoft-SQL/ta-p/2150971 <DIV class="lia-message-template-content-zone"> <P>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.</P> <P>In Talend Studio, you can create a SQL Server metadata connection with integrated authentication.</P> <H3><STRONG><FONT color="#339966">Resolution</FONT></STRONG></H3> <P>To create a SQL Server metadata connection with integrated authentication in Studio:</P> <OL> <LI>From the&nbsp;Microsoft Download Center page, download the JDBC driver package that contains the <STRONG>sqljdbc_auth.dll</STRONG> file to the machine hosting Talend Studio.</LI> <LI>Move the <STRONG>sqljdbc_auth.dll</STRONG> file to the <STRONG>C:\Windows\System32</STRONG> folder.</LI> <LI>Launch Studio, then create a SQL Server metadata connection.</LI> <LI> <P>In the <STRONG>Additional parameters</STRONG> text box, enter <STRONG>integratedSecurity=true</STRONG>.</P> </LI> <LI>Enter the other valid connection properties as needed, then test the connection: <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="0693p000008u9TdAAI.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/123040i5C3D000BC315E773/image-size/large?v=v2&amp;px=999" role="button" title="0693p000008u9TdAAI.png" alt="0693p000008u9TdAAI.png" /></span></SPAN></P> </LI> </OL> </DIV> Wed, 19 Aug 2026 06:52:04 GMT TalendSolutionExpert 2026-08-19T06:52:04Z https://community.qlik.com/t5/Official-Support-Articles/How-do-I-configure-integrated-authentication-for-a-Microsoft-SQL/ta-p/2150971 <DIV class="lia-message-template-content-zone"> <P>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.</P> <P>In Talend Studio, you can create a SQL Server metadata connection with integrated authentication.</P> <H3><STRONG><FONT color="#339966">Resolution</FONT></STRONG></H3> <P>To create a SQL Server metadata connection with integrated authentication in Studio:</P> <OL> <LI>From the&nbsp;Microsoft Download Center page, download the JDBC driver package that contains the <STRONG>sqljdbc_auth.dll</STRONG> file to the machine hosting Talend Studio.</LI> <LI>Move the <STRONG>sqljdbc_auth.dll</STRONG> file to the <STRONG>C:\Windows\System32</STRONG> folder.</LI> <LI>Launch Studio, then create a SQL Server metadata connection.</LI> <LI> <P>In the <STRONG>Additional parameters</STRONG> text box, enter <STRONG>integratedSecurity=true</STRONG>.</P> </LI> <LI>Enter the other valid connection properties as needed, then test the connection: <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="0693p000008u9TdAAI.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/123040i5C3D000BC315E773/image-size/large?v=v2&amp;px=999" role="button" title="0693p000008u9TdAAI.png" alt="0693p000008u9TdAAI.png" /></span></SPAN></P> </LI> </OL> </DIV> Wed, 19 Aug 2026 06:52:04 GMT https://community.qlik.com/t5/Official-Support-Articles/How-do-I-configure-integrated-authentication-for-a-Microsoft-SQL/ta-p/2150971 TalendSolutionExpert 2026-08-19T06:52:04Z