In this article we will discuss how to create an SQL database in Microsoft Azure. Before stating this article we recommend please go through our previous article What is Azure - Introduction to Azure Cloud and How to sign-up for an Azure free account.
As far you know that Microsoft Azure provides for building, testing, deploying, and managing applications and services through a global network of Microsoft-managed data centers. We do also create the SQL Server database into it and use in our application as well.
How to create an SQL database in Microsoft Azure
Logged into your Microsoft Azure account, if you are new to how to login through Azure account then please go through this How to sign-up for an Azure free account.
After logged into the System it navigate to you Azure Portal Dashboard where you can find SQL Server database image link like below then Click the highlighted SQL databases.
After Clicking the SQL databases it navigate to another page where you able to create new database as per below picture.
 |
| You can create new Database by either clicking the Add button or Create SQL database as highlighted. |
Resource Group ( Need to set Manually according to your Convenient) , database name (As per your choice), Server (Need to set Manually according to your Convenient).
As like below set the Resource Group then Database Name
When you click the create New it popped a screen to create server like below; You need to add your server name, and to access database add the credentials ( login and password). Click
OK to set the Server.
After Clicking OK button you can see that it set the server name accordingly. You can add a higher-performance server for your SQL database by clicking "configure database" link as highlighted below. You can see for 10 DTUs and 250 GB storage the amount in Rupees is 991.50 INR.
 |
| If you are migrated to Paid version then you can set the storage |
Then click on Review & Create button it navigate to you the confirm page. Double check of your SQL server configuration then click Create button.
When you made all of your selections and are happy with your SQL database configuration, click the Create button and wait for the resources, and the server to be deployed.
Once the deployment is complete, you can access your new SQL database by navigating to the SQL databases section of your Azure Portal Dashboard and clicking the appropriate database from the list.
Click the Query editor link, log in, and start making queries.
One thing keep in mind is that if your Firewall Settings is not enabled to the Client IP it may popped the below issue to access the server like below;
We already did another article for this type issue it must sort out, please go through link HomeAzure Client with IP address is not allowed to access the server Azure Error
After set the Database Firewall logged with the credentials and it should logged into database. Then Create the script like below and click on Run, after run the script you can see that the table is created and it found in under Tables.
 |
| Wah ! That's we look for |
So, this is so far we will discuss how to create an SQL database in Microsoft Azure. If you are beginner of Microsoft Azure then this article must help you.
Summary
In this tutorial we discussed how to create an SQL database in Microsoft Azure . If have any question related to this topic then give your feedback.
Post a Comment