topic Re: [resolved] trouble connecting with MSSQL with JAVA Talend in Installing and Upgrading

[resolved] trouble connecting with MSSQL with JAVA Talend

Anonymous — Sat, 16 Nov 2024 14:35:01 GMT

hi,
i need to connect to MSSQL using NT AUTHENTICATION (no username or password)
i receive the following message when i try to test the connection:
I/O Error: SSO Failed Native SSPI library not loaded. Check the java.library.path system property.
where do i get started to solve this one?
i understand that it is not a solely Talend problem, but i have not found a solution in java related forum (i am not searching for the right thing)
thanks,

Nicolas

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

Anonymous — Wed, 11 Jul 2007 09:28:47 GMT

In order to use Windows authentification, the MSSQL JDBC driver requires a DLL. Download the driver here : http://sourceforge.net/project/showfiles.php?group_id=33291
You will find in the folder SSO a file called ntlmauth.dll. Put it in c:\windows\system32 and restart TOS. Then create a new MSSQL connection, and leave user & password fields empty. You should be able to connect to MSSQL with your windows account.

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

_AnonymousUser — Thu, 04 Nov 2010 05:30:54 GMT

I've done as jgottero has said but I am still getting the error message. What else can I do/check? I have tried other programs (SQL Server, Advance Query Tool, Aqua Data Studio) and have been able to connect with out any issues. Any help will be much appreciated.

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

Anonymous — Thu, 17 Mar 2011 12:27:55 GMT

In order to use Windows authentification, the MSSQL JDBC driver requires a DLL. Download the driver here : http://sourceforge.net/project/showfiles.php?group_id=33291
You will find in the folder SSO a file called ntlmauth.dll. Put it in c:\windows\system32 and restart TOS. Then create a new MSSQL connection, and leave user & password fields empty. You should be able to connect to MSSQL with your windows account.

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

Anonymous — Thu, 17 Mar 2011 12:45:41 GMT

In order to use Windows authentification, the MSSQL JDBC driver requires a DLL. Download the driver here : http://sourceforge.net/project/showfiles.php?group_id=33291
You will find in the folder SSO a file called ntlmauth.dll. Put it in c:\windows\system32 and restart TOS. Then create a new MSSQL connection, and leave user & password fields empty. You should be able to connect to MSSQL with your windows account.

Bumping an old post. Tried the above and it seems to work. But...
Let's say I want to login using another domain user, how would I do that? If I leave the user & password empty it uses current logged in windows user. But if I specify another domain account user then it returns with an error... Any ideas?
(I have added user and pasword and server in "Manage passwords" in User Accounts)
.....and maybe I was too quick to post!
I added information in the Additional parameters box: user=<USR>;password=<PWD>;domain=<DOMAIN> and it seems to work. I'll go back to sleep...

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

_AnonymousUser — Mon, 21 Mar 2011 14:10:16 GMT

I click on the link for this file and I don't see an SSO folder?

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

Anonymous — Mon, 21 Mar 2011 15:26:51 GMT

I click on the link for this file and I don't see an SSO folder?

Click on the link for the latest version (See text on page looking something like this: "Looking for the latest version? Download jTDS 1.2.5 (535.9 KB)") and download the compressed file (a zip file). Extract the zip package to some temporary folder on your disk. Then you should see a sub-folder called ia64\sso or x64\sso or x86\sso depending on which version you want. For 32-bit OS choose x86\sso\ntlmauth.dll from the zipped package.

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

alevy — Tue, 26 Jul 2011 07:48:56 GMT

Rather than placing the ntlmauth.dll in c:\windows\system32, you should place it in C:\Program Files (x86)\Java\jre6\bin (for 32-bit/x86) or C:\Program Files\Java\jre6\bin (for 64-bit/x64). This will allow both 32-bit and 64-bit Java to use Windows authentication to SQL Server on a 64-bit machine. (32-bit Java on a 64-bit machine does not find ntlmauth.dll in c:\windows\system32.)

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

_AnonymousUser — Tue, 08 Nov 2011 18:42:36 GMT

Hello

I upgraded to Windows 7 Professional x64 and now talend can´t connect to sql server anymore.
I already placed ntlmauth.dll into the bin directories of all java installed and on windows\system32 but still can´t connect.
I can connect on SQL server with iReport just putting the dll on the bin directories.
I´m using the zip version of talend (no installation needed)
Any idea?

Thanks

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

_AnonymousUser — Tue, 08 Nov 2011 18:44:32 GMT

Hi
Just forgot to mention that I tried x32 and x64 talend launchers.
regards

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

_AnonymousUser — Tue, 13 Dec 2011 15:26:14 GMT

Hi
Just forgot to mention that I tried x32 and x64 talend launchers.
regards

Hi,
I have the same problem. Does somebody found a solution in the meantime?
regards
E.

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

Anonymous — Wed, 21 Dec 2011 03:13:10 GMT

Hi
Maybe you could find the solution in the following link:
http://jira.talendforge.org/browse/TDI-18787
Best regards
Shong

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

_AnonymousUser — Mon, 10 Dec 2012 11:52:41 GMT

I added information in the Additional parameters box: user=<USR>;password=<PWD>;domain=<DOMAIN> and it seems to work. I'll go back to sleep...

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

_AnonymousUser — Thu, 13 Dec 2012 17:16:07 GMT

Hi All,
I downloaded the folder and placed the Dll files in two places as mentioned I closed talend and relaunched again I was able to connect using windows authentication but after some time I was not able to again.
help required.
Thanks
Sri

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

_AnonymousUser — Fri, 11 Jan 2013 20:37:42 GMT

The suggested locations above (in the JDK bin, in the JRE bin, in system32) for ntlmauth.dll did not work for me on Windows 7 Pro x64 running the 64-bit TOS on a 64-bit JVM.
I even added a simple little Java component:

System.out.println(System.getProperty("java.library.path"));

...and that included the attempted locations, taken from the system PATH as expected.
However, placing ntlmauth.dll in the root of TOS (same folder as TOS_DI-win-x86_64.exe) made it work. I have an acceptable workaround, but if anybody knows why the other java.library.path locations don't work, I'm curious to know.

Re: [resolved] trouble connecting with MSSQL with JAVA Talend

alevy — Thu, 04 Apr 2013 05:31:07 GMT

For an exported job, ntlmauth.dll can be placed in whatever is the "current directory" when java.exe is called. Since the standard batch file to launch a job changes the current directory to the location of the batch file before calling java, place the DLL in the same folder as the batch file.