topic Microsoft SQL Connection in Installing and Upgrading

Microsoft SQL Connection

Anonymous — Sat, 16 Nov 2024 04:51:25 GMT

Hi,

I'm trying to set up a new DB connection to Microsoft SQL Server, using Windows Authentification.

But when I test the connection, I got this error message:

Connection failure. You must change the Database Settings.
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
etc...

I have seen that many discussions already exist on this subject, but none of the proposed solutions has been able to correct my problem so far.

Here is what I have done:

put jtds-1.3.1.jar on my plugins Talend folder
put ntlmauth.dll on folder "...Jre1.8.0_221/bin"

Those files have been dowloaded from this link: https://sourceforge.net/projects/jtds/

I am using version 7.2 of Talend.

Thank in advance for your help.

Regards,

Vincent

Re: Microsoft SQL Connection

Anonymous — Thu, 29 Aug 2019 04:39:40 GMT

Hello,

Could you please have a try to put the ntlmauth.dll file also to these two folder and then, restart studio to see if it works?
c:\windows\system32 and<Talend Studio install dir>/.

Best regards

Sabrina

Re: Microsoft SQL Connection

Anonymous — Tue, 03 Sep 2019 12:56:48 GMT

Thank you for your help!

Re: Microsoft SQL Connection

Fabi_1 — Thu, 28 Nov 2019 09:00:22 GMT

Thanks for your help.

This solution works when I use one route with 1 jobs or only a job. But when I deploy a second route whith a job usingthe sso.I have this message SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

The SSO works only I have one route.

Have you got any solution to resolve my problem?