Friday, January 01, 2010

Firewall IP address setting in SQL Azure

SQL Azure Portal can be used for setting IP address(s) that are allowed to access SQL Azure databases. The portal comes up with a suggestion for the IP address from where the user is trying to set up the allowed address. This may not be the correct IP address setting(??????) as I found out trying to connect to SQL Azure from an overseas location different from the usual location that I normally use.

Here is the tip:
Probably the correct address that you should set may be obtained by trying to connect to a SQL Azure database from SSMS. If the IP address is not correct, then a error message will be returned indicating that you cannot access the SQL Azure database from such and such an IP address. The IP address in the error message is the one that should be used for firewall setting in the SQL Azure Portal.

No comments: Protection Status