Six Stars

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

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)
 
Inline image 1
 
 
 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.. 
2 REPLIES
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

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

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