Azure Active DIrectory Windows- Azure SQL Database

Nandan Hegde 25,461 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 Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
16,714 questions
Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
5,982 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,276 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.