In this article we are going to see how to manage the newly created SQL Azure database using the Azure management portal.
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
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 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
Clicking on the Manage button will open a new browser as shown in the screen below
Now accept the agreement and click on OK button will navigate to the new window as shown in the screen below
Enter the valid credentials and click on connect button. We will see a Error message at the bottom as shown in the screen below
Click on the Error button, we can see a nice animation it will open the error message as shown in the screen below
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
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
After adding the IP address we can see the IP added to the list as shown in the screen below
Now go back to the Manage portal and give the credentials once again and click on connect button as shown in the screen below
After successful authentication we will be redirected to a new portal as shown in the below screen
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.
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.