I am new to Azure Data Factory, and trying to create a new Linked Service to a Azure SQL Database. However I'm getting an error trying to do so. Below is the ADF linked service creation template.

I'm using a service account, which works when connecting to the Azure SQL database, through Management Studio, using authentication method Azure Active Diretory - Password. Tho I am not able to connect to it with linked service. So I'm asking if it's possible to do with AAD - Password, and if so how?

I am getting the error

Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Cannot open server "emailadress.com" requested by the login. The login failed.

Which makes me wonder if username can contain '@', as the error does not display any of the username letters before @.

CodePudding user response：

Unfortunately, ADF doesnt support AD auth for Azure SQL database:

You are using SQL auth as drop down and in that using AD account because of which it is failing

CodePudding user response：

To connect to Azure SQL database with service principle in ADF linked service, select the Authentication type as Service Principle in the drop-down as mentioned by @Nandan.

And to use the Service principle with Azure AD application token authentication you will need Tenant, Service principal ID (Application ID), and Service principal key (Application Key).

Get these values by creating an Azure Active Directory application. Follow this MS document to register an application with AAD and create a service principle.

Also, refer to this document for prerequisites for using Service Principal authentication.