connecting On prem MS SQL database from azure express route

Question

Hi all,

i have App services , i want to connect on premise MS SQL database using express route , I found many articles about creating express route but not able to find any document, how to configure on-prem database connection through express route, can anyone guide , how to connect On Prem MS SQL database using express route

Answer 1

Hello @azure architect with .net expereince ,

Welcome to Microsoft Q&A Platform. Thank you for reaching out & hope you are doing well.

If you are using ExpressRoute, it would be possible to access the On-Premise SQL Database from the App Service by using regional VNet Integration as this enables your App to access resources across Azure ExpressRoute connections. You can also use App Service Environment.

Using regional virtual network integration enables your App to access:

• Resources in the virtual network you're integrated with.
• Resources in virtual networks peered to the virtual network your app is integrated with including global peering connections.
• Resources across Azure ExpressRoute connections.
• Service endpoint-secured services.
• Private endpoint-enabled services.

Refer : https://learn.microsoft.com/en-us/azure/app-service/overview-vnet-integration#regional-virtual-network-integration https://learn.microsoft.com/en-us/azure/app-service/environment/app-service-app-service-environment-securely-connecting-to-backend-resources

Similar questions for your reference: https://learn.microsoft.com/en-us/answers/questions/179143/index.html https://learn.microsoft.com/en-us/answers/questions/161688/index.html

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

---

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.