Hi Parth,
It seems like you’ve done on your Azure environment. I suggest to do this checklist:
- VNet Integration: Ensure that VNet Integration is properly configured for your web apps. This is necessary for your app service to reach your Azure SQL DB instance.
- Private Endpoint: Verify that the private endpoint for your SQL Server is correctly set up and associated with the correct subnet.
- Connection String: Check the connection string in your web app’s configuration. It should be using the private endpoint’s DNS name.
- DNS Resolution: Ensure that the DNS settings of your VNet are configured correctly. The web app should be able to resolve the private endpoint’s DNS name to its private IP address.
- Firewall Rules: Double-check the firewall rules on your SQL Server. Even with Private Link, the SQL Server’s firewall rules can prevent connections.
- Application Settings: Make sure your application is correctly configured to connect to the SQL Server using the private link.
Using advanced tools(kudo) on the app service you can start testing by curl command to the DB port and verify the proper name resolution.
I hope this help you. If the information helped address your question, please Accept the answer.
Luis