Adal Error while trying to configure Azure AD user and Azure Sql Authentication to make my connection string password less

Question

Hi there,

I'm trying AD integrated authentication between my .net app and azure SQL. The app is running on a Azure VM that is joined to an Azure AD domain (Domain Services) on IIS.

I am getting Adal Error while trying to configure Azure AD user and Azure Sql Authentication to make connection my string password less

Error : One or More errors, AdalException: Integrated Windows authentication supported only in federation flow.

This is how my connection string looks :

<add name="primary" connectionString="Server=tcp:XXXXX;Initial Catalog=XXXXX;Persist Security Info=False;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication='Active Directory Integrated';" />

Answer 1

@Raghava Sai Akula Thanks for posting your question in the Microsoft Q&A forum.

Integrated authentication relies on an Active Directory (Windows) domain that is federated to AAD. It does not work on machines that are joined to Azure Active Directory tenants. This is an AAD requirement. If you want this to work, you will need to configure the VM on a Windows domain and federate to AAD.

Regards

Geetha