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.[more]
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 .