Connect to MSSQL using a domain account

[datajunkie1000]

Hi All

The Problem: how to connect to MSSQL using a specified domain account

I'm able to connect to my SqlServer 2019 database from Talend Studio with the currently logged in user connecting using integratedSecurity. I'm using the Microsoft JDBC provider, added mssql-jdbc_auth-8.2.2.x64.dll to my JAVA_HOME and added the integratedSecurity=True in the Additional JDBC Parameters. So far so good. 

but...

I need to connect to the database using a different domain account, not the currently logged in user. How do I do that in Talend Studio and how would I set that user in Talend Management Console?

Thanks in advance guys!!!

[manodwhb]

You can create a connection understand metadata of repository and you can use it in the jobs.

[datajunkie1000 · Accepted solution]

I found the missing parts of the puzzle:

1. You need to use the open Source JTDS driver, not the Microsoft provider

2. add "useNTLMv2=true;" to the additional parameters.

The metadata connection is then