Step-by-step tutorial to connect MS SQL Server to Talend Open Studio using windows authentication.

Summary :

Download the jtds-SQL server JDBC driver from jTDS – SQL Server and Sybase JDBC driver download | SourceForge.net, It will download in the form of the zip file, unzip it with the help of 7-zip.
Copy jtds-1.3.1.jar to ‘plugins’ of the Talend folder.                                                                                                                   
Based on your CPU architecture, copy ntlmauth.dll from x64/SSO OR x86/SSO OR IA64/SSO folder to <JDK_HOME>/bin folder.
Copy these DLL file into below location                                                                 
After doing this open [SQL server 2019 configuration manager]
Next, Open SQL server network configuration manager and set all the status to enable.
Right click on TCP/IP properties and copy the TCP ports Number.
And left click on SQL server (SQL 19DEV) and click on restart as shown below.
Now open talend and click on metadata and create a new Db connection in that select DB type as Microsoft SQL server and Db version as Open source JTDS.
After than specify your SQL server login and password, the server name as  localhost, Port number, Database, and schema, and hit on the test connection.Happy Learning….!