Grant admin-level privileges on Azure SQL database

In order to run the PowerShell script required in the next section, admin-level access on the Azure SQL database is required.

1. Type “Resource groups" in the Azure portal search bar and select said option as it appears.

   
2. Find the managed resource group that was created earlier in the deployment process (step 6 of the managed application creation process).

   
3. An overview page will open which will display all the resources. Select the SQL database server.

   
4. Select Microsoft Entra ID (under Settings) from the left pane.

   
5. Click on Set admin and search for the user account IDs/usernames needing admin access on the right pane in the search bar. Click on Select.

   
6. Click on Save.