Azure Active DIrectory Windows- Azure SQL Database

Nandan Hegde 22,206 Reputation points
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 Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
13,646 questions
Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
4,924 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,251 Reputation points Microsoft Employee
    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.