Floating FB popout byF5debug

Windows Azure – Creating New Database Server in Azure Portal



In this article we are going to see how to create a New database server in Azure Management portal.


Database servers are created for each subscriptions based on the level of the registered account. Each subscription can contain multiple logical Azure database servers. Each server is created based on the region selected at the time of configuration of the server. Once the server is created we can see a read only Master database is created automatically with some login credentials. We can create our own database after the serves are configured correctly based on our requirement.



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 New Database server option at the Left top corner of the screen. This option will help us to configure the New database server as per the requirement.

Click on the New Database Server option will navigate to the Database tab as shown in the screen below


Here we can see the different options to create a new database server with the registered subscription. Now Click on the Subscriptions menu at the left side. We can see the registered subscription as shown in the screen below


Now since we have the subscription ready we can create a new serve by clicking on the CREATE option at the top right tool bat as highlighted in the below screen


We can see a new popup window asking to select the region on where to reside the server as shown in the screen below


Select a particular region based on our requirement and click on Next button will show option to create a new server asking for the login and the password details as shown in the below screen


Provide some valid login credentials and click on the next button. While entering the password some password policy is enforced by Microsoft as shown in the screen below


Once the valid password is given and clicking on the next button will move to the next screen where it will be asking for the IP range which acts as a firewall as shown in the screen below. We need to specify the IP Address from which we connect to the Azure database and do the access. This option is provided to make a secure connection and without specifying the IP address we will not be able to connect using the SQL server management studio.


Click on the ADD button will open the window to add the IP address as shown in the screen below


We can see YOUR CURRENT IP ADDRESS will be shown at the bottom which specifies the current IP from which we accessing. Just copy and paste the same to add it to the firewall. After adding Click on Finish button to complete the process.

Now we can see the Server created as shown in the screen below.


Click in the server name will provide the server details as shown in the screen below


Since this subscription is the free version we can see the Max Size is 1GB for each database. We can see the Master database created on its own with current size as 0B.


So in this article we have seen on how to create a new database server from the Azure management portal and add the configuration details to be accessed across .

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