Sqlconnectionstring using managed identity in sql trigger

Diana Boone 26

I have an azure function that has a connection string that needs to use the managed identity assigned to it. The managed identity is a user assigned identity. What is the syntax of the connection string ?

Shireesha Eeraboina (Quadrant Resource LLC) 5 Reputation points Microsoft Vendor

2024-10-29T16:51:58.16+00:00

Hi @Diana Boone ,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

For a user-assigned managed identity, you will need to specify the client ID of that identity when acquiring a token to access Azure resources. Here’s a general approach for setting this up, particularly for Azure SQL Database

Connection String Format:- Server=tcp:.database.windows.net,1433; Database=<your-database-name>; Authentication=Active Directory Managed Identity;

Example:- Server=tcp:myserver.database.windows.net,1433; Database=mydatabase; Authentication=Active Directory Managed Identity;

I hope that this response will address your query and helped you overcome your challenges.

If you find this answer helpful, please click "Accept Answer" and kindly upvote it.

Thankyou.
Shireesha Eeraboina (Quadrant Resource LLC) 5 Reputation points Microsoft Vendor

2024-10-30T15:39:04.74+00:00

Hi @Diana Boone ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Thankyou.
Shireesha Eeraboina (Quadrant Resource LLC) 5 Reputation points Microsoft Vendor

2024-11-01T17:04:06.8166667+00:00

Hi @Diana Boone ,

We haven't heard back from you. Please reply if you have any questions in this matter and we will gladly continue the discussion.

Thankyou.

Share via

Sqlconnectionstring using managed identity in sql trigger

Your answer