topic Re: MS SQL connect - authentication issue in Installing and Upgrading

MS SQL connect - authentication issue

Anonymous — Sat, 16 Nov 2024 04:41:17 GMT

Just installed Talend v7.2.1 (community).

Downloaded the MS SQL JDC driver and did a manual add to the modules, as well as the TALEND patches (see screen shots)

I am having an issue using windows authentication (NTLM) with the JDBC (JTDS) drivers.

I have followed the directions in: https://www.youtube.com/watch?v=pXFazmPcqX8

I have no troubled connecting to PostGreSQL databases with normal (non NTLM) credentials.

It seems it is connecting, but the password is failing. I have no problem with the username/password connection to the MS SQL DB when using VIsual Studio 2017.

Re: MS SQL connect - authentication issue

Anonymous — Tue, 17 Sep 2019 04:31:16 GMT

Hello,

Are you able to connect sqlserver database via telnet using port like : telnet localhost 1433?

Best regards

Sabrina

Re: MS SQL connect - authentication issue

Anonymous — Tue, 17 Sep 2019 18:58:06 GMT

I have updated the issue. As stated above, VS2017 can connect to the the MS SQL, but there is some sort of an issue with the JDBC drivers and windows authentication (NTLM?)