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

One Star

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

Kindly find the attached img for your reference.

Regards,
Priyanka 
One Star

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

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
One Star

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

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
Highlighted
One Star

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

Thanks for the update Priyanka.