Grant a SQL Server Admin Role

Edit online

About this task

To enable Azure SQL backup service, the SQL server admin role is required to grant to the delegated app. Follow the steps below to add a SQL server admin role for the app you want to use to protect Azure SQL databases.

Procedure

  1. Go to Azure portal > Azure SQL.
  2. Click your app name and navigate to Settings > Microsoft Entra ID.
  3. In the Microsoft Entra ID page, click Set admin.
  4. Select your admin group and then click Select.
  5. After selecting, click Savetosave changes.
  6. Navigate to Security > Networking > Public access tab.
  7. In the Public network access field, select Selected networks to enable public network access.
  8. In the Exceptions field, select the Allow Azure services and resources to access this server option.