Connect an App Service Web app to a SQL Server database inside a Virtual Machine

Question

Hi,

I'm migrating an ASP.NET Web Site to Azure Stack Hub App Service.

The Web Site uses a SQL Server database, I have instaled a Virtual Machine in the same Resource group as the App Service but the Web Site can't connect to the database.

I have tried with the private and public IP but nothing.

How can this be accomplish?

Thanks!
I

Answer 1

The SQL Server instance was a named instance and the SQL Server Browser service was stopped....

Telnet testing to 1433 worked fine, but without that service connection to named instances do not work

Now it works perfectly!!

Thank you all for the support

Answer 2

Here a few things to check @FERNANDO VENDRAMIN ,

• Check your VNET integration for your app. If you don't have that setup see https://learn.microsoft.com/en-us/azure/app-service/web-sites-integrate-with-vnet. Verify that from the app service console test-netconnection hostname [optional: -Port] completes successfully.
• Make sure that you have service endpoints enabled for the VNET and any subnets you configured
• Check your firewall settings for you VM. You may have deny public access; see https://techcommunity.microsoft.com/t5/azure-database-support-blog/lesson-learned-126-deny-public-network-access-allow-azure/ba-p/1244037 for more info.

Answer 3

Hi @FERNANDO VENDRAMIN , want to clarify a couple of items here:

1. The VM on which you have deployed SQL Server is in the same resource group as the Web App, correct?
2. Have you opened the necessary ports on the VM firewall to allow inbound traffic to SQL Server (usually port 1433 TCP as a minimum)?
3. You will need to configure your connection string to point to the Public IP of the VM as there is not support for VNET integration in Azure Stack Hub.

Thanks

Andrew