CODEWITHSUNDEEP
visual-studioazure-functionsazure-sql-databaseazure-managed-identity
Vkumar
Vkumar

Reputation: 13

Connecting C# Azure Function with Azure SQL using User-Managed Identity. Authentication Failed

Connecting C# Azure Function with Azure SQL using User-Managed Identity. Authentication Failed

Upvotes: 1

Views: 1126

Answers (1)

Delliganesh Sevanesan
Delliganesh Sevanesan

Reputation: 4786

Connecting C# Azure Function with Azure SQL using User-Managed Identity. Authentication Failed

Normally, the Connection String varies based on the type of authentication where User ID and Authentication Values will be varied.

enter image description here

As @Scott Mildenberger suggested that MS Doc that states to add the attribute User Id=ClientIdOfManagedIdentity in the Connection String of Database Server when specifying the application configuration settings.

In your case also, Authentication and UserId values are set to be Active Directory Managed Identity and ClientIdOfManagedIdentity and then it has to be deployed to reflect the changes and work.

Upvotes: 0

Related Questions