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
3. Execute the talend job, it will usewindowsauthentication (This is working Fine)
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..