Remediation

From Azure Portal

1. Go to SQL servers.
2. For each SQL server, under Settings, click Microsoft Entra admin.
3. Click on Set admin.
4. Select an admin.
5. Click Select.
6. Click Save.

From Azure CLI

az ad user show --id {{user-principal-id}}

For each Server, set AD Admin:

az sql server ad-admin create \
    --resource-group {{resource-group-name}} \
    --server {{server-name}} \
    --display-name {{display-name}} \
    --object-id {{object-id}}

From PowerShell

For each Server, set Entra ID Admin:

Set-AzSqlServerActiveDirectoryAdministrator `
    -ResourceGroupName {{resource-group-name}} `
    -ServerName {{server-name}} `
    -DisplayName "{{display-name}}"