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


Top 5 Contributors of the Month
Jean Paul
Subhransu Sekhar Jena
satyapriyanayak
SP
abhays

Home >> Articles >> Azure >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Creating New Database Stored Procedure in Azure Portal in SQL Azure

Posted By:Karthikeyan Anbarasan       Posted Date: June 27, 2011    Points: 200    Category: Azure    URL: http://www.f5debug.net/  

In this article we are going to see how to create a new database stored procedure using the new Azure portal instead of using the SQL Server Management Studio.
 

 

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 servers 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 are made very easily with the latest version of Azure using the manage database option. Let's see how to use this manage option to develop a fully functioning database.


Steps:


Log in to the Azure portal using the link below. You will 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. 

image 

Now we can see the Database Menu at the bottom left; click on that to go to the Database Subscription window as shown in the screen below: 

image 
Clicking on the subscription name will show the complete details of the server created and the new database created as shown in the screen below: 

image 

Now we have a database created with a maximum size of 1GB and are 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. 

image 

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

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

image 
Enter the valid credentials and click on connect button. We will see an error message at the bottom as shown in the screen below: 

image 

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

image 


image 

From the error message we can see that the IP address is not added to the firewall. Since this managing server is maintained in a 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: 

image 

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 the ADD button to add the new IP address to the firewall. 

image 

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

image 

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

image 

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

image 

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

 

Conclusion:

 

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


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

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