Windows Azure – Configure Firewall for SQL Server Connectivity

Facing connectivity issues while connecting from client to Azure SQL Server database? Security settings in Windows Azure mandates that the firewall must be configured with a range of IP addresses to allow connectivity to server. The steps below demonstrates how to set this from Azure portal.

Login to your Azure account at

SQL databases ->  Select your database -> Settings


Under Firewall settings, you can specify specific IP addresses or range of IP address from which you want to allow connections to your SQL server database. Even though the time delay to effect this is specified as 5 minutes, most of the time the changes are reflected instantly.




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s