Connection failure to SQL Server using active directory

Anonymous — Wed, 22 May 2019 13:57:24 GMT

Hello!

I have a context variable group for connection. Their I have created a "local" context with my company's username and password. I added additional parameters as sendStringParametersAsUnicode=false;trustServerCertificate=true;authentication=ActiveDirectoryPassword

Now the issue is when I try to retrieve schema or run the job using this local context variable, Talend throws error saying

Connection failure, check the database settings or contact your database administrator.

Detailed error:

Connection failure, check the database settings or contact your database administrator.
java.lang.RuntimeException: java.lang.UnsatisfiedLinkError: com.microsoft.sqlserver.jdbc.AuthenticationJNI.ADALGetAccessToken(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;JLjava/util/logging/LoggerLcom/microsoft/sqlserver/jdbc/FedAuthDllInfo;
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:204)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1139)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:386)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:320)
at org.talend.repository.ui.wizards.metadata.table.database.SelectorTableForm$8.run(SelectorTableForm.java:1105)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
Caused by: java.lang.UnsatisfiedLinkError: com.microsoft.sqlserver.jdbc.AuthenticationJNI.ADALGetAccessToken(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;JLjava/util/logging/LoggerLcom/microsoft/sqlserver/jdbc/FedAuthDllInfo;
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.ADALGetAccessToken(Native Method)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.getAccessToken(AuthenticationJNI.java:81)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.getFedAuthToken(SQLServerConnection.java:3637)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.onFedAuthInfo(SQLServerConnection.java:3605)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.processFedAuthInfo(SQLServerConnection.java:3572)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onFedAuthInfo(tdsparser.java:290)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:94)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4346)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3160)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:43)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3123)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1981)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)

I also imported the Microsoft JDBC Driver 6.0 for SQL Server (sqljdbc-auth.dll). Still it didnt work. Which driver then should I use?

Regards

Priyadarshini

Re: Connection failure to SQL Server using active directory

akumar2301 — Wed, 22 May 2019 14:02:02 GMT

did you already try below link

https://medium.com/@cannyinformatic/talend-mssql-connection-using-windows-authentication-76ca20f612b

Re: Connection failure to SQL Server using active directory

Anonymous — Wed, 22 May 2019 14:35:04 GMT

I am accessing SQL server with client's windows authentication. But I am using my laptop with my own credentials and not client's. Can I use the same solution in this case too? I was thinking about the integratedSecurity point mentioned in the article.

Regards

Priya

Re: Connection failure to SQL Server using active directory

Anonymous — Mon, 27 May 2019 15:19:23 GMT

There was missing sqldll in my java bin folder. once i added that and added the same dll in modules in talend, it started working.

Regards

Priya

Re: Connection failure to SQL Server using active directory

spachunuri — Thu, 15 Apr 2021 00:22:20 GMT

Hi Priya,

Do you know which dll you are referring here. I am also having the same issue.

topic Re: Connection failure to SQL Server using active directory in Talend Studio

Connection failure to SQL Server using active directory

Re: Connection failure to SQL Server using active directory

Re: Connection failure to SQL Server using active directory

Re: Connection failure to SQL Server using active directory

Re: Connection failure to SQL Server using active directory