#cannyinformatics #talend #mssql
Step by step tutorial to connect MS SQL Server to Talend Open Studio using windows authentication.

Tutorial Prepared by Canny Informatics, http://www.CannyInformatics.com

Tutorial Summary
Solution –
1. Download jtds- SQL server database driver from https://sourceforge.net/projects/jtds/
– Copy jtds-1.3.1.jar to ‘plugins’ of Talend folder
– From X64 – SSO folder ntlmauth.dll to jdk1.8.0_102 – bin folder –
– select folder according to the windows version

2. In SQL Server Network Configuration set all Protocols to Enabled.
– Copy TCP dynamic ports value from TCP/IP protocols property from the end of the page.
–
3. In Talend Metadata – DB Connection;
– DB Type = Microsoft SQL Server
– DB Version = Open Source JTDS
– Specify your Server name and Database
– In additional parameters = integratedSecurity=true “most important”
– In SQL Server Network Configuration set all Protocols to Enabled.
– Use TCP dynamic ports from TCP/IP protocols property.
– For me, Port number: 52890 us this port in ‘port’ property
– Check Connection

► If you need help growing your business using data analytics check out Canny Informatics and Contact us at http://www.cannyinformatics.com/contact for reporting, BI and ETL and data warehousing services.

► Visit our blog at http://www.cannyinformatics.com/blog for more technical articles on ETL, BI, Reporting and Data Warehousing.