Unabel to connect with MSSQL with Microsoft Authentication AD ID

Six Stars

Unabel to connect with MSSQL with Microsoft Authentication AD ID

Hi,

I'm using Talend Integration Cloud Enterprice Solution.

I'm trying to connect with MSSQL with microsoft authentication ADID but I'm getting error.

When I'm able to connect with same ADID by MSSQL suite.

I'm not getting why talend not providing this facility in there tool, this is basic connection for all organiztion.

I have created a genric JDBC connection with some external jars and dll file like sqljdbc_auth.dll.

It's working fine in my local talend developer studio. But again when I'm deploying to Talend Cloud same error I'm getting like "unknow user", might be some external required jars and dll files are not deployed.

Some one tell me how I will resolved this issue?

Moderator

Re: Unabel to connect with MSSQL with Microsoft Authentication AD ID

Hello,

Could you please indicate on which talend build version you got this issue? So far, talend uses the jtds jar and jtds connection string.

Could you please create a new connection in metadata with all the required parameter for  MSSQL DB (tMSSqlConnection) type instead of generic JDBC type to see if it is OK with you?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Unabel to connect with MSSQL with Microsoft Authentication AD ID

Hi,

I'm using the talend integrate cloud studio 6.4.


@xdshiwrote:

Hello,

Could you please indicate on which talend build version you got this issue? So far, talend uses the jtds jar and jtds connection string.

Could you please create a new connection in metadata with all the required parameter for  MSSQL DB (tMSSqlConnection) type instead of generic JDBC type to see if it is OK with you?

Best regards

Sabrina



I select MSSQL server connection and in that I selected the Microsoft Authentication and insert all required paramete like user name password. I'm using AD ID as user. In that I'm getting error like:

Connection failure. You must change the Database Settings.
  java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'VSTAGE/jarindurad'. ClientConnectionId:f9ef1b72-05e3-4f81-9e39-9496836aa130
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1047)
      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$62.runWithCancel(DatabaseForm.java:3983)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.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: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'VSTAGE/jarindurad'. ClientConnectionId:f9ef1b72-05e3-4f81-9e39-9496836aa130
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)
      at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:256)


@xdshiwrote:

Hello,

Could you please indicate on which talend build version you got this issue? So far, talend uses the jtds jar and jtds connection string.

Could you please create a new connection in metadata with all the required parameter for  MSSQL DB (tMSSqlConnection) type instead of generic JDBC type to see if it is OK with you?

Best regards

Sabrina


 

Moderator

Re: Unabel to connect with MSSQL with Microsoft Authentication AD ID

Hello,

Are you able to connect to your MSSQL with microsoft authentication ADID through client without using talend tool?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Unabel to connect with MSSQL with Microsoft Authentication AD ID

Yes, I'm able to connect with Microsoft authentication AD-ID without talend tool

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now

Modern Data Engineering in the Cloud

Learn about modern data engineering in the Cloud

Watch Now

How to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud reg...

Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries

Blog