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

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

Thanks for the update Priyanka. 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read