Skip to main content


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

Azure SQL database server is a logical container for managing databases and elastic pools.

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

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

Create Microsoft Azure 30 days Trial Version

Follow the below steps for creating Azure SQL Database Server.

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

Step 2: Search for SQL Servers in the search bar and Click on SQL servers.

Step 3: Click on Create.

Step 4: Choose the Subscription.

Step 5: Choose the Resource group or Click on Create new to create new resource group.

Step 6: Provide the Unique Resource Group Name and Click on OK.

Step 7: Provide the Unique SQL Database Server name and choose the nearest Location.

Step 8: Choose the required Authentication method.

For this article, am selecting the Use both SQL and Azure AD authentication.

Step 9: Click on Set admin to Set the Azure AD admin.

Step 10: Search for the required User or a Group from the Azure Active Directory.

Step 11: Click on the required User or a Group and Click on Select.

Azure AD admin was selected.

Step 12: Provide the Server admin login, Password and Confirm password and Click on Next : Networking >.

Note: Copy and Paste the Server admin login and password in a secured place for using it later.

Step 13: Click on Next : Additional settings >.

Step 14: Click on Next : Tags >.

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

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

Step 16: Click on Create.

Validating… and Submitting Deployment…

Deployment is in progress.

Step 17: Azure SQL Database Server has been created. Click on Go to resource.

Microsoft Azure SQL Database Server Overview can be seen here.

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

Like and share your valuable feedback on this article.

This was originally posted here.


*This post is locked for comments