Microsoft Account members are not allowed (as admin in Azure DB)

ivan zhukov 10 Reputation points

Hello! I want to set up AAD connection to my Azure DB in Azure Data Studio, but i have an error: "Login failed for user '<token-identified principal>'." Aftersome ivestigations i found the article: . It says that i have to set an AAD admin in my SQL instance. But if i try to set my main account as admin, i see, that: "Microsoft Account members are not allowed" see pic: (AzureAdmNotAllowed


What i do wrong?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
747 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
104 questions
{count} votes

1 answer

Sort by: Most helpful
  1. TP 82,241 Reputation points


    You need to select a Azure AD user instead of a Microsoft Account user. If you don't have one you want to use you may create a new user in Azure Active Directory.

    In the Azure portal, Azure Active Directory -- Users, Azure AD users will have <yourdomain> in the Identities column instead of MicrosoftAccount. Similar to screenshot below:

    azure ad user vs microsoft account user

    If the above was helpful please click Accept Answer.



    0 comments No comments