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

ivan zhukov 10 Reputation points
2023-05-01T20:52:50.11+00:00

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: https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell&view=azuresql . 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
    2023-05-09T00:42:27.4566667+00:00

    Hi,

    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>.onmicrosoft.com 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.

    Thanks.

    -TP

    0 comments No comments