Firewall Settings for Connecting to Azure SQL Databases from an Azure VM

Author by Frank Gill

Recently, I was helping a colleague troubleshoot connectivity issues between an Azure VM and Azure SQL Database.  The client architecture looks like this:

RFSNetworkDiagram.jpg

The failing connections were coming from the DMZ.  Watching network traffic using Wireshark, we saw an attempt to connect to the Azure SQL Database on port 11029.  A Google search led me to the following link:

https://docs.microsoft.com/en-us/azure/azure-sql/database/adonet-v12-develop-direct-route-ports

From the link:

Ensure that the port ranges of 11000-11999 on your Azure client machine are left available for ADO.NET 4.5 client interactions with SQL Database.

After opening port 11029 to the DMZ server the connections succeeded.  Azure Support provided this link to explain why the port range is required.

https://docs.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture

I was unaware of this requirement before this and hope that this will help others who encounter this scenario.

Tags in this Article