In SQL Management Studio you get the following messaage when trying to connect to an Azure Database:
"Cannot connect to mydbname.database.windows.net."
"Cannot open server 'mydebname' requested by the login. Client with IP address '255.255.255.255' is not allowed to access the server. To enable access, use the Windows Azure Management 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. (Microsoft SQL Server, Error: 40615)"
Like most things in Azure, once you know how, it’s easy. Just finding out how can be incredibly tortuous!
From the machine you want to configure SSMS access for, log in to your Azure Management Porta dashboard.
Now click on the Azure SQL server you want to grant access for (not the individual databases unless you want to grant one by one).
Then select Firewall settings on the far right:
There is a nice option to add the current client IP, or (one by one only) you can create new rules. Just don’t try to add more than one at a time before saving.
Now go have a cup of tea and when you come back: you wish will be granted!