I have successfully configured a SQL 2008 VM in Azure, added an end point which maps through to port 1433 and set up a windows firewall rule for inbound traffic to connect to SQL server.
The next setting I wanted to apply was to limit the remote IP addresses which can access the SQL server. Windows Azure endpoints configured in the portal do not allow IP restriction, so I went to Windows Firewall advanced settings, inbound rules and added the IP address of my office in the scope setting (remote IP address) of the Firewall rule. Applying these IP addresses resulted in access being denied from both locations (generic server does not exist/unavailable message). I checked and re-checked and I have the correct IP addresses in scope. I remove the IP scope settings and I can connect again.
Any ideas on why the firewall/SQL server would not be able to apply the Remote IP address scope setting correctly?