Unable to create new Db connection for ms sql server windows auth
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
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
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
