SQL Azure access control

Category: azure sqlazure


Apurva Samudra on Mon, 08 Apr 2013 20:35:12

While sp_set_firewall_rule allows controlling access using IPs. Is there any way to control access using domain names like example.com?


Mike Lewis (SQLTuna) on Tue, 09 Apr 2013 08:41:11

In short, no.  You need to use IP addresses and specify a range (which can be just a single IP address).

If you don't have a static IP, and can't get one, then you need to find the range of IPs in which you will be dynamically assigned, and open up that range.

Failing that, you can open up the entire spectrum and rely on username/password as your security, but that's obviously not recommended....

Apurva Samudra on Wed, 10 Apr 2013 16:54:06