Floating FB popout byF5debug

SQL Azure – Manage Database using Azure Portal

 

Introduction:

In this article we are going to see how to manage the newly created SQL Azure database using the Azure management portal.

Overview:

Managing database server and the database itself using SQL Azure is something new which we can see in the latest version provided using Silverlight. Once we create a new Storage account and a new server with new database  we need to manage that database to create tables, stored procedures etc. which made very easy with the latest version of Azure using the manage database option.

[more]

Lets see on how to use this manage option to develop a fully functioning database

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/

clip_image001

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

clip_image003

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

clip_image004

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

clip_image005

Now we have a database created with a Max size of 1GB and ready to use it for the application based on the requirement. To manage the database click on Manage at the top menu tool bar as shown in the screen below

clip_image006

Clicking on the Manage button will open a new browser as shown in the screen below

clip_image007

Now accept the agreement and click on OK button will navigate to the new window as shown in the screen below

clip_image008

Enter the valid credentials and click on connect button. We will see a Error message at the bottom as shown in the screen below

clip_image009

Click on the Error button, we can see a nice animation it will open the error message as shown in the screen below

clip_image010

clip_image011

From the error message we can see that the IP address is not added to the firewall. Since this managing server is maintained in different IP we need to add this as well to the Firewall rule. To add the IP to the firewall rule do the following steps. Go to the Azure portal and add the IP as shown below

Now we can see the Firewall Rules tab with the added IP address as shown in the screen below

clip_image012

Click on that button will drop down the list of IP address added as shown in the screen below. Here we need to Click on ADD button to add the new IP address to the firewall

clip_image013

After adding the IP address we can see the IP added to the list as shown in the screen below

clip_image014

Now go back to the Manage portal and give the credentials once again and click on connect button as shown in the screen below

clip_image015

After successful authentication we will be redirected to a new portal as shown in the below screen

clip_image016

We can use this portal to do some updates like adding new table, stored procedure, Views etc along with adding data to the tables which we will see in our upcoming articles.

Conclusion:

So in this article we have seen on how to connect to the new Manage server to manage the database created newly using SQL Azure.

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

Pingbacks and trackbacks (1)+

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

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.

Protected by Copyscape Web Plagiarism Finder

Site Meter