topic Re: Connect to MSSQL using a domain account in Talend Studio

Connect to MSSQL using a domain account

datajunkie1000 — Sat, 16 Nov 2024 02:20:29 GMT

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!!!

Re: Connect to MSSQL using a domain account

manodwhb — Mon, 25 May 2020 16:16:25 GMT

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

Re: Connect to MSSQL using a domain account

datajunkie1000 — Tue, 26 May 2020 11:31:50 GMT

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