Floating FB popout byF5debug

Windows Azure – Creating New Database Server in Azure Portal

 

Introduction:

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

Overview:

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.

[more]

Steps:

Log in to the Azure portal using the below link. You can see the screen look similar to below

http://www.microsoft.com/windowsazure/

clip_image001

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

clip_image003

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

clip_image004

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

clip_image005

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

clip_image006

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

clip_image007

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

clip_image008

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

clip_image009

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.

clip_image010

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

clip_image011

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.

clip_image012

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

clip_image013

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.

Conclusion:

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

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

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