In trying to connect to a SQL server database that I set up in Azure I get this error each time I try and interact with the database from a different location. If I add a rule that allows the client IP address at that location the error doesn't occur. I access the internet from a number of locations. Do I have to add every client IP address or is there a way to add a rule that picks up my computer and allows me in from anywhere?
Firewall check failed. Cannot open server 'XXXXXXXXX' requested by the login. Client with IP address 'XXXXXXXXX' is not allowed to access the server. To enable access, use the SQL Azure Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect.