Unable to create new Db connection for ms sql server windows auth

Anonymous — Sat, 16 Nov 2024 10:20:42 GMT

Hi Team,
i am totally new to Talend data quality tool.
Can anybody guide me how to create new db connectio for Ms sql server for windows authentication.?
i am trying to create the new db connection for sql server 2012 for windows authentication and while checking the connection , it throws an error 'Connection failure , you must change the database settings.
Error Details:
Connection failure. You must change the Database Settings.
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:654)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:371)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1063)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$46.runWithCancel(DatabaseForm.java:3173)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$46.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.IOException: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:1963)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:617)
... 12 more

Kindly find the attached img for your reference.

Regards,
Priyanka

Re: Unable to create new Db connection for ms sql server windows auth

Anonymous — Wed, 05 Oct 2016 04:54:04 GMT

Somehow the jar files ued by the talend open edition does not let you use the Windows authentication with SQL. We had similar issue and we had to create a SQL database user for this connection to work

Re: Unable to create new Db connection for ms sql server windows auth

Anonymous — Wed, 05 Oct 2016 07:53:20 GMT

Hi Sankalp
Thank you so much for your reply.
I found solution for above query.
I have downloaded janet.dll and placed it under 'C:\Program Files\Java\jre6\bin ' folder.
Kindly refer below link for more details.
http://talendforge.org/wiki/doku.php?id=doc:dotnet

Regards,
Priyanka Kadam

Re: Unable to create new Db connection for ms sql server windows auth

Anonymous — Wed, 05 Oct 2016 08:53:33 GMT

Thanks for the update Priyanka.

Re: Unable to create new Db connection for ms sql server windows auth

Muhammad_irtiza — Sat, 30 Jan 2021 10:22:47 GMT

Above solution of PriyankaKadam works for me. Thanks for sharing the answer

topic Re: Unable to create new Db connection for ms sql server windows auth in Data Quality

Unable to create new Db connection for ms sql server windows auth

Re: Unable to create new Db connection for ms sql server windows auth

Re: Unable to create new Db connection for ms sql server windows auth

Re: Unable to create new Db connection for ms sql server windows auth

Re: Unable to create new Db connection for ms sql server windows auth