0

I trying connect to azure sql server (xxxx.database.windows.net) through datacenter ip addres, i changed connect policy by proxy, but now i don't know how connect to instance the sql server.

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

Juan Sebastian Santa H.
  • 1

1 Answers1

0

You may have to add the datacenter IP range as a rule on the Azure SQL Database firewall rule. Please download and read this document to know the current IP range of the datacenter where your database resides.

Alternatively you can also set "Allow Access to Azure Services" to On (see image below), although this option configures the firewall to allow all connections from Azure including connections from the subscriptions of other customers.

enter image description here

In addition to configure the firewall, for security reasons make sure your login and user permissions limit access to only authorized users.

This guide may provide you additional valuable information to connect to your Azure SQL databases.

Martijn Pieters
  • 1,048,767
  • 296
  • 4,058
  • 3,343
Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
  • Looking at the IP range list of the data center, I do not see the region of south central us, I also observe a large number of ip's. Should I attach all the corresponding ones to my region? at the end of all this process I seek to connect to my azure database through the own ip of the datacenter – Juan Sebastian Santa H. Mar 05 '19 at 16:28
  • You should add all the IP because a SQL Server endpoint could associated with any IP. As you can see on this link, the feature of allowing access by region has been requested by another Azure customer before and you can vote for it https://feedback.azure.com/forums/217321-sql-database/suggestions/35186611-allow-acces-to-azure-services-by-region – Alberto Morillo Mar 05 '19 at 17:02