Azure App service failing to connect to the Azure SQL VM Server

Question

The connection string of my .NET application to connect to the database has been provided in the configuration of an Azure App service and the database is present in an Azure SQL Virtual Machine, when trying to access the APIs of my application I see the following error,

“A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct, and that SQL Server is configured to allow remote connections. (Provider: TCP Provider, error: 0 - Access is denied”

However, I am able to connect to the database via local system’s SSMS on VPN of our Organization with same credentials used as of connection string.
Appreciate if you could help!

Answer 1

Hi,

This is a very common issue and Microsoft provide a step-by-step Troubleshooting document. Please follow the link bellow:

https://learn.microsoft.com/en-us/troubleshoot/sql/connect/network-related-or-instance-specific-error-occurred-while-establishing-connection?WT.mc_id=DP-MVP-5001699

If you have specific step which is not clear then pls elaborate and we will provide more details :-)

Answer 2

Following reference is an excellent example scenario describes how to securely connect a web app to a backend database over a fully private connection. The architectures ensure communication from the web app in Azure App Service and Azure SQL Database only traverses a virtual network.

private-web-app

Please have a look and see if it helps to resolve the issue

----------

--please don't forget to upvote and Accept as answer if the reply is helpful--