Floating FB popout byF5debug

SQL Azure – Adding and Removing Firewall Rules in Azure Portal



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


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.


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


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.


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.

About 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.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

  • Comment
  • Preview

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters


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.

Protected by Copyscape Web Plagiarism Finder

Site Meter