Unable to login to Azure SQL database thru Azure App Service using User Managed Identity

Question

Unable to login to Azure SQL database thru Azure App Service using User Managed Identity

mksharma 0 Microsoft Employee

I am trying to connect to an Azure SQL Database from an Azure App Service using User Managed Identity.

I have created a Managed Identity, granted it permissions to the database. I have also added the identity into the App-Service.

The code to connect to the database is as follows:

credential = identity.DefaultAzureCredential(exclude_interactive_browser_credential=False)
            
token = credential.get_token("https://database.windows.net/.default").token.encode("UTF-16-LE")
token_struct = struct.pack(f'

Bryan Trach 17,842 Reputation points Microsoft Employee Moderator

2023-12-03T18:38:10.9533333+00:00

@mksharma Based on the code snippet you provided, it seems that you are trying to connect to an Azure SQL Database from an Azure App Service using User Managed Identity. However, it is not clear what specific issue you are encountering.

If you are unable to login to the Azure SQL Database, there could be several reasons for this. One common issue is that the firewall rules for the database may not be configured correctly to allow traffic from the App Service. You may need to add the IP address of the App Service to the firewall rules for the database.

Another issue could be related to the permissions granted to the Managed Identity. Make sure that the Managed Identity has been granted the necessary permissions to access the database.

If you are still encountering issues, you may need to provide more information or context about the problem so that I can better assist you.
Bryan Trach 17,842 Reputation points Microsoft Employee Moderator

2023-12-03T18:38:56.7633333+00:00

@mksharma Also, it appears that your code snippet was cut short in your post.