Hey, My guess is you are using Self hosted IR to access your SQL MI database via ADF . Can you please confirm on that ? If that is the case, ADF dataflow doesnt support Self IR sources thereby leading to a failure in connection
Error when connecting to Azure SQL Database from Azure Data Factory
I am trying connecting data factory to SQLMI using Managed identity. I was able to create the linked service and the test connection was successful. I tried a copy pipeline to query the SQL database and copy it to a storage account and that worked. I created a dataset and could preview the data from there. However, when I tried using that dataset in a data flow (also tried inline data) the connection fails and give this error: Cannot connect to SQL database: 'jdbc:sqlserver://(server name), 'Managed Identity (factory name): (name)'.[SQL Exception]Error Code:18456, Error Message: Login failed for user '<token-identified principal>'. ClientConnectionId:3dda9792-95c4-4561-aab2-66b28bf0b2ff, error stack:shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
Cheah, Felix FC •,
We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Sign in to comment