Problem creating SQL database with Azure Active Directory

Scott Bryant 0 Reputation points
2023-04-24T15:27:51.9333333+00:00

I'm new to Azure so I know I am missing something. Cannot figure out what. I have created an Active Directory for my organization, and am now trying to create a SQL Database. I want Mixed Authentication, so on the Create SQL Database Server page, it shows Set Azure AD admin. I click the Set Admin, and I see a list of Azure Active Directories. But My Active Directory is not shown in the list. My Microsoft Account Member (who I am logged in as) is listed, but is not selectable. I created another user in my active directory and they are not shown in this list either. What have I missed here? Any/All help greatly appreciated. Thank you

Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,629 questions
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
    2023-04-27T00:00:40.5933333+00:00

    @Scott Bryant Have you tried checking under users as mentioned above

    Under "Subscription", make sure that your subscription is associated with your Active Directory.

    If your subscription is not associated with your Active Directory, click on "Change Directory" and select your Active Directory.

    Once your Active Directory is associated with your subscription, you should be able to set an Azure AD admin for your SQL Database server. If you continue to have issues, you can try creating a new Azure AD user and adding them to your Active Directory, then try setting them as the Azure AD admin for your SQL Database server.

    Also can you please confirm if you are looking at the right place? Are you looking for a list of users in the Active Directory? as shown below

    User's image

    Regards Geetha

    1 person found this answer helpful.
    0 comments No comments