Share via

Azure AD Admin only sees 1 SQL Database

Binway 716 Reputation points
2020-07-27T02:59:42.217+00:00

Hello Folks,
I have two Azure SQL Databases on an Azure SQL Server. I have added an Azure AD group to which I belong as Admin to the server. When I log into the server using ssms with my login with the Azure Directory - Universal with MFA support I can only see one of the SQL Databases. I cannot see anything that is different between the two databases in the properties for each on the Portal eg the Server Admin and active directory admin are both populated the same.
Can you tell me what I might be missing please.

Thanks.

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.
23,056 questions
0 comments
Accepted answer
  1. Binway 716 Reputation points
    2020-07-27T04:14:02.67+00:00

    Found the issue. I had been testing connectivity via Azure AD groups and was having some issues where one possibility was to change the default database in the options from Default to a specified database. I did not change it back so was only viewing the selected database.
    ![13719-defaultdb.jpg][1]
    Change it back to default and all good now.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.