Header add

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.

After clicking Create SQL database it navigate to the below page where you need to provide the Subscription( Our case it is Free trail, if you already upgraded your account then choose accordingly),
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

Azure will default to the Standard pricing tier, but if you want to consider adding a higher-performance server for your SQL database. The basic pricing tier starts at $4.99/month for storage of up to 2GB. The Standard tier starts at $15/month for 250GB, and the Premium tier starts at $465/month for 500GB. Select Apply when you have made your decision.

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.

After click the create button it will take some seconds to create database for you. After that you find the database setup is completed. Then Click "Go to resource" button that are highlighted.

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.

     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.

You May Also Like...

Post a Comment

Previous Post Next Post