question

PontusIreteg-7132 avatar image
1 Vote"
PontusIreteg-7132 asked PontusIreteg-7132 edited

Azure SQL Data Sync Agent - firewall ip range from on premise

Hi!

I'm trying to find what DNS names and/or IP ranges the Azure SQL Data Sync agent (on premise) will be using for connecting to the Azure SQL Data Sync agent in Azure so we could open the correct ranges in our firewall. I have used Wireshark to find some ranges (51.103.5.1xx seems to be one) over HTTPS.

The SQL traffic goes via our Express route and is already working.


Thanks in advance!


BR,
Pontus

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo commented

Here you will find IP ranges for SQL services (and other services) on Azure.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you Alberto!

Did not find the exact IP range that Wireshark shows for my on premise Azure SQL Data sync agent or a name of the segment for that range.

I'll close this ticket since this is close enough.



Br,
Pontus

1 Vote 1 ·

The IP address of your SQL Database server will always be a part of the address ranges listed in the list. You Windows Azure Datacenter IP Rangesshould allow outgoing traffic for port 1433 to these address ranges rather than a specific IP address.
Source: Here


0 Votes 0 ·
PontusIreteg-7132 avatar image
1 Vote"
PontusIreteg-7132 answered PontusIreteg-7132 edited

This is the on premise SQL Data Sync agent that uses some IP ranges in Azure and not Azure SQL.
We are connecting from on premise using the Azure SQL Data Sync agent via Express Route to our Azure SQL database but we still need https opened to Azure for the agent. That IP range I'm looking for information about.

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-agent-overview

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.