Floating FB popout byF5debug

SQL Azure – Creating New Database in Azure Portal



In this article we are going to see how to create a database from the scratch using SQL Azure using the online Azure Management portal.


Before we create a database on the Azure portal, we need to check the availability of the Subscription and then create a new server (Check article on creating new Server in Azure portal). Once we have done with these steps then we are in the right track of creating a database. As in SQL Azure creating database is something like creating a normal SQL database locally but it will be available in the cloud. Let us see on the steps to create a new 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 Menus at the Left bottom of the screen, Select Database menu will navigate to a page where we have the server created as shown in the screen below


Now we can see a server is ready hosted with a Master database. we can create our own database by doing the steps below.

Click on CREATE button located at the top Menu bar under database section as shown in the screen below


It will open a popup as shown in the screen below asking for the Database name and the size of the database. Since its Web edition we have option to have 1GB as the maximum.


Provide a valid Database Name for your requirement and click on OK button to move to the next window. Now we can see a new database is created with default of 0B as size as shown in the screen below



In this article we have seen on how to create a new database by doing some basic configuration.

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

  • Comment
  • Preview

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters


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