Share via

ADF fails to connect to Azure SQL Database using Managed Indentity

Fernando Hidalgo 101 Reputation points
2021-08-17T17:07:32.267+00:00

Hi,

I am trying to connect to an Azure SQL Database but I get a generic connection error:

Cannot connect to SQL Database: 'mysqlserver.database.windows.net', Database: 'dwh', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Login failed for user '<token-identified principal>'., SqlErrorNumber=18456,Class=14,State=1, Activity ID: e108df0e-c804-406c-85c4-4d99814b0527.

  • My SQL server has the firewall with the option "Deny public network access" to "No"
  • "Allow Azure services and resources to access this server" is set to "Yes"
  • My ADF and my SQL Server are in different regions.
  • This was working until I moved the whole Resource Group from a directory to another directory.
  • I run the Set-AzDataFactoryV2 to renew the Identity of my ADF.

I tried to create a new ADF but now it does not allows me to create the user for the principal.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Answer accepted by question author
  1. Fernando Hidalgo 101 Reputation points
    2021-08-18T08:21:05.13+00:00

    Thanks Shaik,

    It is solved now. I deleted the SQL Server +Database and I recreated it. (there was not much on it)

    I think it was something related to the SQL Server coming from another directory as I moved the Resource Group between two tenancies.

    Kind Regards,
    Fernando Hidalgo

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.