# Grant admin-level privileges on Azure SQL database

In order to run the PowerShell script required in the [next section](execute-the-powershell-script-in-windows-powershell-ise), admin-level access on the Azure SQL database is required.

1.  Type “**Resource groups**" in the [Azure portal](https://portal.azure.com) search bar and select said option as it appears.&#x20;

    &#x20;

    <figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FTHzI5HR0WuoYOLZUZqve%2F14.2.png?alt=media&#x26;token=695a1eac-6a9c-4c8d-b531-eed2ece6fb7e" alt=""><figcaption></figcaption></figure>
2.  Find the managed resource group that was created earlier in the deployment process (step 6 of the[ managed application creation process](../../deploy/deploy-automatically-via-azure-marketplace#create-a-managed-application)).&#x20;

    <figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FgutlXSPPuYZuFxbNfW5L%2F14.9.png?alt=media&#x26;token=f21bcfc8-2894-4854-8168-df2e184e7906" alt=""><figcaption></figcaption></figure>
3.  An overview page will open which will display all the resources. Select the SQL database server.&#x20;

    <figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FUJtbGWEBO1V37sk5gqBq%2F14.10.png?alt=media&#x26;token=6012a878-6f61-4bc4-bfdc-6d4d375ddb70" alt=""><figcaption></figcaption></figure>
4.  Select **Microsoft Entra ID** (under Settings) from the left pane.&#x20;

    <figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FHtzIQxIPHAyWx4zlmT6v%2F13.6.png?alt=media&#x26;token=3d0c1284-f1f3-4ae6-845b-4e563745ace2" alt=""><figcaption></figcaption></figure>
5.  Click on **Set admin** and search for the security group created earlier in the search bar. Click on **Select**.&#x20;

    <figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FqdY6vfX3EyP0EOsK4TyP%2F13.7.png?alt=media&#x26;token=f4a58d6c-9d72-420f-b9b7-135261b50f8c" alt=""><figcaption></figcaption></figure>
6.  Click on **Save**.&#x20;

    <figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2Fuk0YQrYlMFESueHVqaL5%2F13.8.png?alt=media&#x26;token=448156f0-94bb-4789-84f2-3c37296d334a" alt=""><figcaption></figcaption></figure>
