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

EnterpriseArchitect 4,761 Reputation points
2020-11-13T06:46:41.967+00:00

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,

Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,158 questions
Azure ExpressRoute
Azure ExpressRoute
An Azure service that provides private connections between Azure datacenters and infrastructure, either on premises or in a colocation environment.
323 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sumarigo-MSFT 43,801 Reputation points Microsoft Employee
    2020-11-17T09:26:12.65+00:00

    @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.

    1 person found this answer helpful.
  2. SaiKishor-MSFT 17,196 Reputation points
    2020-11-17T18:34:36.84+00:00

    @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!

    0 comments