How to Create Azure SQL Database in the Microsoft Azure Portal?

Microsoft Azure SQL Database is a managed cloud database provided as part of Microsoft Azure. A cloud database is a database that runs on a cloud computing platform, and access to it is provided as a service. Managed database services take care of scalability, backup, and high availability of the database.

In this article, will explain about creating the Azure SQL Database in the Azure Portal.

Pre-requisite:

  1. An active Azure Subscription and If you do not have one, follow the steps provided in the below article and create the Azure 30 days Trial version.

    Create Microsoft Azure 30 days Trial Version
  2. Follow the steps provided in the below article and create Azure SQL Database Server in Azure.

    Create Azure SQL Database Server in the Microsoft Azure Portal

Follow the below steps for creating Azure SQL Database.

Step 1: Click here to navigate to Microsoft Azure Portal and login using your credentials.

Step 2: Search for SQL databases in the search bar and Click on SQL databases under Services.

Step 3: Click on Create or Create SQL database.

Step 4: Choose Subscription and Resource group.

If you want to create a new Resource group, click on Create new.

Step 5: Provide the Unique Database name, select the Azure SQL Database Server (As mentioned in the Pre-Requisite) and Compute + storage based on your need.

Note: Click on Configure database to see multiple options related to Compute + storage.

Choose the required compute + storage options based on vCore-based purchasing model or DTU-based purchasing model and click on Apply.

Step 6: Choose the required Backup storage redundancy and Click on Next : Networking >.

Step 7: Select the required options related to Firewall rules and Private endpoints and Click on Next: Security >.

Step 8: Click on Next: Additional settings >.

Step 9: Click on the Sample for the Use existing data and Click on OK.

AdventureWorksLT related Tables and sample data will be created after the SQL Database creation.

Step 10: Click on Next : Tags >.

Step 11: Provide Tags and Click on Next: Review + create >

For this article, I had provided the below Sample Tags.

Step 12: Review all the details and if required, Click on < Previous.

If everything is fine, Click on Create to start the Database creation.

Validating…

Deployment is in progress.

Step 13: Deployment is completed. Click on Go to resource.

Azure SQL DB Overview can be seen.

Step 14: Click on Query editor (preview).

Step 15: Enter the Login and Password and Click on OK.

Now, you can see Query editor of the Azure SQL Database.

Note: You might get the below error related to Firewall rule. If yes, Click on Allowlist IP X.X.X.X on server sqldbsvr-ap.

Firewall rule is updated.

Refresh the page and continue with Step 15.

Step 16: Enter the below query in the Query 1 window and Click on Run to see the Results.

Select * from [SalesLT].[Customer]

Step 17: Click on Connection strings to see the list of all connection strings that can be used to connect from Microsoft SQL Server Management Studio or Azure Data Studio or from other tools.

Note: SQL DB Password text {your_password} must be replaced in the connection string with the correct password before using the connection string in .

Hope you have successfully followed all the steps and created the Azure SQL Database in the Azure Portal.

Like and share your valuable feedback on this article.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.