"Cannot open serverrequested by the login. Client with IP address is not allowed to access the server" while accessing SQL Azure

When you are using SQL Azure Database you may end up with this error ""Cannot open server requested by the login. Client with IP address is not allowed to access the server" at time development. This is due to because you Azure firewall settings does not allow you system to access the sql server as it is not been listed as permitted IPs . To do the following you can login to windows azure and select your database and choose the menu option dashboard as show below.

You can click on manage and it does automatically reads your IP and prompts to add that in the permitted IP list as shown below.

Once you say OK now you are good to go and access your database from your development environment.