No option to select user managed identity for SQL Server

Question

I already have an Azure SQL server in my RG. I created User assigned managed identity and try to assign to SQL but it is not happening.

In the portal tried - the list is empty and not showing managed identity

No user assigned managed identities were selected. Select one or more user assigned managed identities you want to assign to this resource

Answer 1

Hello Srinivasa Rao Reddimsetti

There are a few possible reasons why you are not able to assign the user-assigned managed identity to your Azure SQL server.

• The user-assigned managed identity may not be in the same subscription as the Azure SQL server.
• The user-assigned managed identity may not have the correct permissions to access the Azure SQL server.
• The user-assigned managed identity may not be enabled.

To troubleshoot this issue, you can check the following:

• Make sure that the user-assigned managed identity is in the same subscription as the Azure SQL server.
• Check the permissions of the user-assigned managed identity. The user-assigned managed identity must have the "Azure Service Management" permission to access the Azure SQL server.
• Make sure that the user-assigned managed identity is enabled.

If you have checked all of these things and you are still not able to assign the user-assigned managed identity to your Azure SQL server, you can contact Azure support for help.

Here are the steps on how to assign a user-assigned managed identity to an Azure SQL server in the Azure portal:

1. Go to the Azure portal and select the Azure SQL server.
2. Click the Security tab.
3. Click the Identity setting.
4. Under User assigned managed identity, click Add.
5. Select the user-assigned managed identity that you want to assign to the Azure SQL server.
6. Click the Select button.
7. Click the Save button.

Once you have assigned the user-assigned managed identity to the Azure SQL server, you can use the managed identity to access Azure resources that are protected by Azure Active Directory (Azure AD). For example, you can use the managed identity to access Azure Storage blobs or Azure Key Vault secrets.