Azure Web Application Connectivity Issue with Disabled Public Endpoint

Question

After creating a private endpoint in US East, the Azure Web Application is working and connecting to the Azure SQL DB server (in other region). However, it is unable to access the data when the public endpoint is disabled

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings!

Welcome to Microsoft Q&A forum.

You need to create the private endpoint in VNET\Subnet in the region where the Azure web application is hosted and created the necessary NSG rules.

The root cause of the connectivity issues stems from the regional discrepancy between the Azure SQL DB server and the Azure web application. The Azure SQL DB server and its Private Endpoints were initially set up in the US East region, whereas the Azure web application was hosted in a different region

To resolve the connectivity issue, recreate the private endpoint for the Azure SQL DB server in the VNET/Subnet located in the same region as the Azure web application. Additionally, ensure that the necessary NSG rules are created to facilitate this connection. This approach will allow the Azure web application to access the database using the Private Endpoint by successfully disabling the public endpoint

Thank You!