Microsoft Entra managed identities provide a secure, credential-free method for Azure resources to authenticate and authorize with other services that support Microsoft Entra authentication.
Both system-assigned and user-assigned managed identities are supported.
Procedure
-
Set the managed identity as the Microsoft Entra admin in the Microsoft Entra ID settings of the Azure SQL server you want to protect.
-
Configure the managed identity with the required permissions listed in Role and Permission Requirements for Protecting Azure Resources at the resource group level, at a minimum.