app service and vm in azure with same virtual network

Question

I have a small site which build on .net framework and I want to host the site in azure app service with basic pricing tier.

I want to avoid using sql databases service azure because of pricing.

So that I want to host my database in VM, because I already have the sql server licence.

Is it possible to map the database in VM with the app service?

Please suggest the better ways of doing it.

Answer 1

From your description, you want to host SQL Server on Azure VM. It's possible to access the DB on Azure VM from App service.

Here are two options for you:

• Integrate your app with an Azure Virtual Network. If so, you need to upgrade to a Standard or Premium Plan to configure a VNet.
• App Service integration with hybrid connections. It enables your app to access a single TCP endpoint per hybrid connection.

In my opinion, VNet integration is better to use need TCP and UDP connections and it also works with function apps. The Hybrid connection is better to use that you want to provide access from multiple networks. For example, you can access the DB from the on-premise network.

For more references, you could read this blog.