MS SQL connect - authentication issue

[Anonymous]

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.

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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?)