Network to connect web app to SQl MI

frexville 51 Reputation points
2022-11-21T20:57:18.65+00:00

Hello

We have a SQl MI database and a web app that we need to connect trough a Managed Identity.
I followed this tutorial and everything is done
We have a few rules into a Network Security Group, where we whitelist the IPs trough TCP port 3342 inbound
we whitelisted the web apps but we are still getting this error message
Anyone can help with this message ? thanks

An exception has been raised that is likely due to a transient failure. Consider enabling transient error resiliency by adding 'EnableRetryOnFailure()' to the 'UseSqlServer' call.

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,326 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. JimmySalian-2011 42,066 Reputation points
    2022-11-21T21:12:43.343+00:00

    Hi Frex,

    Check this thread on SOF and there is a fix that you need to apply on the SQL DB, consider-enabling-transient-error-resiliency-by-adding-enableretryonfailure

    Hope this helps.
    JS

    ==
    Please Accept the answer if the information helped you. This will help us and others in the community as well.