Azure Active DIrectory Windows- Azure SQL Database

Nandan Hegde 29,886 Reputation points MVP
2020-12-21T09:17:43.27+00:00

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?

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,086 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,389 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2020-12-21T09:43:38.03+00:00

    @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.