SQL Azure - New Feature to add Multiple Servers to single Subscription in Azure portal

Article

Introduction:

This article explains how to create mutiple servers for a single subscription, an additional new feature provided by Microsoft in this May 2011 release for Azure

Overview:

Normally for the developer license (Free license) we are restricted to a single subscription with a single server creation for that subscription with a limitation of 2 or 3 databases for that server. But the latest release provides an added advantage of adding mutiple servers with a single subscription registered with Windows and SQL Azure. Let us see how to create mutiple servers using the Azure Management Portal step by step going forward.

Steps:

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

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 to 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 click on the subscription again and select the CREATE option under server category as shown in the screen below (Check Pointer pointed to).

Now we get a popup to select the region where the new server is to be created, for the purpose of this explanation let's select a different region server as shown in the screen below. (The last time we selected SouthEast Asia and this time we select EastAsia.)

Now create the credential details for the server as we wish which must be in common with the existing server as shown in the screen below:

Now we can see the new server is created with a different region; we can see the server name changed consistently with the server region as shown in the screen below.