Blog Post

Azure Database Support Blog
2 MIN READ

Lesson Learned #327: Why is important to use SQL Service Tag in your NSG?

Jose_Manuel_Jurado's avatar
Feb 10, 2023

Today, we got a service request that our customer has 30 databases in a server but was not able to connect of 3 of them. Following I would like to share with you my findings here. 

 

All the databases in this server 'XXX' are standalone databases and there is not possible to connect within Azure but it is possible to connect from OnPremise. 

 

After analyzing the details we found that our customer has Default connection policy that means that connecting from Azure we are going to use Redirection and from OnPremise they are going to use Proxy.

 

When you are using Redirection you need to know that besides connecting to the GW and port 1433 you need to connect to another port between 11000-12000 and another virtual name as we explained in these URLs:

 

Lesson Learned #216: Hands-On-Labs: How redirect connection policy type works - Microsoft Community Hub

Lesson Learned #203: How can I know that my connection is using Redirect connectivity policy? - Microsoft Community Hub

Azure Support Academy: How to troubleshoot connectivity issues in Azure SQL DB - Part 1 - Microsoft Community Hub

Lesson Learned #258: Python vs Connection Refused with Login timeout expired - Microsoft Community Hub

 

Unfortunately, in the NSG of the Virtual Machine from Azure the have some IPs to connect to Azure SQL Database using 11000-12000 but not all of them were defined. In a dynamic environment it is better to use SQL or SQL<Region> as outbound to avoid this issue in the further. If not you are going to receive error code like 10060.

 

 

Enjoy!

Published Feb 10, 2023
Version 1.0
No CommentsBe the first to comment