.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Post New Resource Bookmark and Share   

SQL Azure - Adding and Removing Firewall Rules in Azure Portal

Posted By:Karthikeyan Anbarasan       Posted Date: June 28, 2011    Points: 200    Category:    URL: http://www.dotnetspark.com  

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

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

http://www.microsoft.com/windowsazure/

image

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

screenshot_02

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

image

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

image

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.

image

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.

image

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.

image

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.



     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend