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:

http://www.windowsazure.com/en-us/services/management-portal/

http://www.windowsazure.com/en-us/

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

Windows-azure-managment-portal1

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.

How-to-manage-sql-azure-database2

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

  1. Log into the Windows Azure portal
  2. 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.

Windows-Azure-SQL-Database3

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.

Logging-into-sql-database4

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.

Here is what it looks like on our computer monitor.

Administration-of-sql-cloud-database5

Now you are at the database level.

SQL Database Related Links

Happy New Year 2014!!

This entry was posted in Administration, Cloud database, What is SQL Azure, Windows Azure Platform and tagged , , . Bookmark the permalink.

Comments are closed.