SSO Failed: Native SSPI library not loaded Talend in ( tMSSQLInput Component)

ashif2 — Fri, 06 Oct 2017 10:40:35 GMT

I am running my talend jobs using Windows NT Authentication by following the below steps:

Design time configuration:

1. Copy ntlmauth.dll to bin folder inside talend installed location. bin folder wont be present, create your own.

2. While executing the job, go to Advanced settings and select "Use Specific JVM arguments" and add the following additional argument

-Djava.library.path=./bin

3. Execute the talend job, it will use windows authentication (This is working Fine)

Problem:

In the same machine, when i execute the batch which is built over the same job and keep the bin folder with ntlmauth.dll in the folder containing .bat file .
I am getting the SSO Error like below:

Exception in component tMSSqlInput_17
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:615)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:226)

When copy the same batch to someother machine , it is working fine ..

Can anyone know why this kind of error occurs and how to fix this error..

Re: SSO Failed: Native SSPI library not loaded Talend in ( tMSSQLInput Component)

Anonymous — Tue, 10 Oct 2017 07:08:52 GMT

Hi
Have a try to put the ntlmauth.dll file also to these two folder:
c:\windows\system32 and<Talend Studio install dir>/.

Then, restart studio and export the job script again.

Regards
Shong

Re: SSO Failed: Native SSPI library not loaded Talend in ( tMSSQLInput Component)

ashif2 — Tue, 10 Oct 2017 12:02:44 GMT

I am getting this issue when i run the batch created over the talend job...

topic Re: SSO Failed: Native SSPI library not loaded Talend in ( tMSSQLInput Component) in Talend Studio

SSO Failed: Native SSPI library not loaded Talend in ( tMSSQLInput Component)

Re: SSO Failed: Native SSPI library not loaded Talend in ( tMSSQLInput Component)

Re: SSO Failed: Native SSPI library not loaded Talend in ( tMSSQLInput Component)