Windows Azure Client with IP address XXX XXX XXX XX is not allowed to access the server

Question

In Windows Azure, I've set up a server, a database, and a firewall setting (rule). Under the Windows Azure Firewall Tab, I've added the IP In firewall setting, which is populating.

This problem notice appears when I try to connect to a database using Manage from Azure Platform.

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.

Furthermore, I am unable to connect using SQL Server Management Studio. For My IP Address, I'm getting the same connection issue error.

I don't have a static IP address, but it hasn't changed during this procedure. I tried several examples, but they all said to add a firewall rule, which I had already done.

Answer 1

With the latest version of Windows Azure, all you have to do is go to the firewall settings and click on add client IP and you'll be ok.