Microsoft Entra service principals provide a secure method for authenticating and accessing Azure SQL resources without relying on individual user credentials.
Procedure
-
Set the service principal as the Microsoft Entra admin in the Microsoft Entra ID settings of the Azure SQL server you want to protect.
-
Configure the service principal with the required permissions listed in Role and Permission Requirements for Protecting Azure Resources at the resource group level, at a minimum.