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

Eight 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.. 
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
Eight 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...

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch