Windows Azure - Creating New Database Server in the Azure Portal


Introduction:


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

Overview:


Database servers are created for each subscription 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 servers are configured correctly based on our requirement.

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 "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, which will navigate to the Database tab as shown in the screen below:
image
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:
image
Now since we have the subscription ready we can create a new server by clicking on the CREATE option at the top right tool bar as highlighted in the screen below:
image
We can see a new popup window asking to select the region on where to put the server as shown in the screen below:
image
Select a particular region based on our requirement then click on the Next button; the option will be shown to create a new server asking for the login and the password details as shown in the screen below:
image
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:
image
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.
image
Click on the ADD button; a window will open to add the IP address as shown in the screen below:
image
We can see YOUR CURRENT IP ADDRESS will be shown at the bottom which specifies the current IP from which we are accessing. Just copy and paste the same to add it to the firewall. After adding click on the Finish button to complete the process.
Now we can see the Server created as shown in the screen below.
image
Click in the server name; it will provide the server details as shown in the screen below:
image
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 how to create a new database server from the Azure management portal and add the configuration details to be accessed across.