sql server - Randomly shows The remote name could not be resolved: "<hostname>" after deploying in azure -
our web api based app has lot of external service calls including keyvault , azure sql database. after deploying in azure appservice randomly getting lot of exception saying "the remote name not resolved:". getting exception keyvault , other external call used httpclient.
sql database getting exception "the underlying provider failed on open." innerexception a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: tcp provider, error: 0 - no such host known.)", in local machine(iis) not gets exceptions , occurs randomly. badly stucked this. have idea?
for sql database possibly caused connection timeout. should increase connection timeout 30 seconds (can set in connection string or connection object) , should include retry logic in app.
Comments
Post a Comment