Using Windows Azure Management Portal with SQL Database

Windows Azure Management Portal gives you an idea of how your subscribed services are performing in the cloud environment. The Windows Azure Portal is supported in multiple languages so it gives you additional functionality. The portal supports the following services:

Web Sites

Virtual Machines

Mobile Services

Cloud Services

SQL Databases

Storage

HDInsight

Media Services

Service Bus

Visual Studio Online

BizTalk Services

Recovery Services

Networks

Traffic Manager

Management Services

Active Directory

Today we are specifically going to focus on SQL Databases component within the Windows Azure Management Portal. We have already provision a Web edition SQL Database with Windows Azure services. Please review our other blogs posts on how to deploy SQL Database with Windows Azure.

You can log into Windows Azure Portal from multiple sites. We are including two of them here:

Afer we logged in, we got the following screen capture. It shows that we have a SQL database named Sales and Status=Online

Next we would like to manage our SQL Database that’s available under the Windows Azure subscription. For this click on SQL Databases in the left navigation bar. You will see two tabs in the right pane, one highlights the databases, the other one servers.

In order to administrator we need to connect to the actual SQL Azure database. So there really are two different steps:

Log into the Windows Azure portal

Then log into SQL database (formerly known as SQL Azure database)

Next click on Manage button available in the bottom middle. When we did that we got the following message.

This basically means that our current IP address is not included in the Firewall Rules, rules that are setup to control access to our data. My frens, that is a good thing! Click on Yes. If you get a Pop-up message, add Microsoft.com to the acceptable sites.
Next we are prompted to log into our server. You will need the following info:

Server

Database

User

Pwd

Here is what it looks like on our end.

After we enter the correct info, we are finally at the SQL Database administration level. In this blog post, we are not going to cover the details of DB Administration. We have existing blog post and plan on writing about new functionality.

The SQL Azure Tutorials and SQL scripts told me exactly what I needed to know and helped me get the job done. Did not spend days online reading about it, followed along and just did it! Awesome training!!