Azure Active DIrectory Windows- Azure SQL Database

Question

Hello All,
I have created an Azure VM with SSMS installed from which I am able to login to an Azure SQL database via Active directory password authentication.
But I am unable to login to the database via Active directory integrated.
Getting the below error :

Integrated Windows authentication supported only in federation flow. (System.Data)

So can someone guide me what steps I need to take?

Answer 1

@Nandan Hegde Thank you for reaching out.
Integrated authentication works when your Active directory is federated.

You should domain join the Azure VM to your domain and login to the VM with your Azure AD credentials.

If your Azure AD is not already set up for federation, please refer to the below.

Deploying Active Directory Federation Services in Azure
Azure AD Connect and federation

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.