Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
Windows Azure - Creating New Database Server in the Azure Portal
WhatsApp
Karthikeyan Anbarasan
13y
6.5k
0
0
100
Article
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/
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, which 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 server by clicking on the CREATE option at the top right tool bar as highlighted in the screen below:
We can see a new popup window asking to select the region on where to put the server as shown in the screen below:
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:
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; a window will open 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 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.
Click in the server name; it 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.
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.
.net
Azure
C#
Database Server in Azure Portal
how to create New Database Server in Azure Portal
VS 2010
Windows Azure
Up Next
Ebook Download
View all
The Implementation & Handling of Multiple Microsoft Chatbot Modules
Read by 3.2k people
Download Now!
Learn
View all
Membership not found