Steps and proedure for Connecting Azure App Service to the Local OnPremise SQL Database via Express route ?

Question

Hi All,

My company has already established the ExpressRoute so my Corporate OnPremise network can access Azure resources internally.

Could someone please share the steps for me to connect the app service to Express Route so the Azure App Service can connect to the OnPremise SQL database?

Public Internet Users –--> Application Gateway (WAF) –--> App Service –--> Local OnPremise SQL Database

Thanks,

Answer 1

@EnterpriseArchitect Thanks for raising this question! Firstly, apologies for the delay in responding here and any inconvenience this issue may have caused. Kindly try the following steps to isolate the issue:
There is also a similar thread discussion in SO and Q&A, please refer to the suggestions.

Additional information: Please refer to this blog, If you still find any difficulties, please let us know we would like to work closer on this issue.

Hope this helps!

Kindly let us know if the above helps or you need further assistance on this issue.

---------------------------------------------------------------------------------------

Please don’t forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

@EnterpriseArchitect
You can access your on-premise resources(in your case, the SQL DB) from App Services via Expressroute if you implement either App Service VNET integration (regional) or App Service Environment. Here is a document that explains this setup further- https://learn.microsoft.com/en-us/azure/app-service/web-sites-integrate-with-vnet#how-regional-vnet-integration-works. However, since your SQL DB is on-premise, this will add some delay due to the process of fetching data from the on-premise. Once you have setup the connection to on-prem, you can ping any resource from the on-premise to confirm the connection.

You can also achieve this using Hybrid Connection (this does not use Express Route). Here is a doc explaining this further- https://learn.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections.

Please let me know if you have further questions/concerns. Thank you!