SQL Azure – Adding and Removing Firewall Rules in Azure Portal

Introduction:

In this article we are going to see how to Add and Remove Firewall Rules using the Management portal in SQL Azure.

Overview:

SQL Azure Firewall rules are provided to protect the data and to prevent access restrictions to the SQL Azure database. Firewall grants access to the originating IP’s from which we are trying to access the database. In order to configure the firewall we need to configure a range of acceptable IP addresses upon which we try to connect to the SQL Azure server using the Management portal or with the SQL Server Management Studio.

[more]

Let us see the step by step process of adding rule and deleting the rule as per our Ip configurations.

Steps:

Log in to the Azure portal using the below link. You can see the screen look similar to below

Login to the portal using your Microsoft Windows Live credentials with Azure credentials to the management portal and you will see the screen as shown in the screen below

Now we can see the Database Menu at the bottom left, Click on that will go to the Database Subscription window as shown in the screen below

Clicking on the subscription name will provide the complete details of the server created and the new database created as shown in the screen below

Now we are open to add the Firewall rules to configure the acceptable IP addresses from which we can access the SQL Azure database. In the sample shown below we have address IP address of HOME servers. Similar way we can configure IP address of Office and other acceptable one’s as per our requirement.

Now lets see on how to add a new IP to the firewall. Click on the ADD button as shown in the screen below, before notice to select the database server as well if we have more than one subscription open to use.

Now we can see a pop-up window asking for the IP addresses Start and End range. Here we can configure a series of IP’s or to configure a single IP provide the that IP in both Start and End range as shown in the screen below. Also there is straight forward option of from which IP we are trying to access the portal now (Your Current IP address). We can just copy and paste that IP if we are going to try from that server itself.

Now we can see that the IP Range is added to the firewall rules as shown in the screen below. We can Delete or Update the IP address by clicking on the IP address and select the appropriate action.

We can configure to add, delete or update as many Firewall IP’s as per our requirement.

Conclusion:

So in this article we have seen how to configure firewall rules on how to add / delete / update them based on our requirement using the SQL Azure management portal.

Author

Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

Site Counter

Awards

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.