I am not able to set an admin for Microsoft Entra ID when creating an SQL server

Question

I am not able to set an admin for Microsoft Entra ID when creating an SQL server  When creating a new server, I want it to support only Microsoft Entra ID Authentication. For authentication method, I leave the default selection selected 'Use only Microsoft Entra ID authentication'. When I click 'Set admin'  the side box opens but I get an error that states 'You are not authorized to make some of the requests. Results may be incomplete

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greeting!

The following permissions are required to utilize or create Microsoft Entra logins in the virtual master database.  

·        Microsoft Entra admin permission or membership in the login manager server role. The first Microsoft Entra login can only be created by the Microsoft Entra admin.

·        Must be a member of Microsoft Entra ID within the same directory used for Azure SQL Database.

·        By default, newly created Microsoft Entra logins in the master database are granted the VIEW ANY DATABASE permission.

Please refer the below documents for more information

 Microsoft Entra server principals - Azure SQL Database & Azure SQL Managed Instance & Azure Synapse Analytics | Microsoft Learn

Regards

Geetha