Create Your First Azure SQL Database Using Azure Portal

Overview:

In this article, we will talk about how we can create a new database in Azure SQL. We will learn each step in a brief manner.

Most of the time when we are beginners in Azure we always have a question how we can create a database in Azure SQL. It’s very easy and simple.

So now let’s get started!

Step 1

Go to https://portal.azure.com/

Step 2

From Left Side > Select SQL Databases

Click on Add button

Step 3

It will ask following information to create a database.

• Database Name = Name of Database
• Subscription = Subscription for Azure Account
• Resource Group = Resource Group for Database
• Select Source = Select which kind of database we want to create
• Server = Name of the server which we have configured. First time when we are creating a database there will no server created. So, we need to configure a server first. We will check how we can create a new server in our next step.
• Pricing Tier= Choose appropriate Pricing plan for Azure SQL Database.

We will add following information.

Step 4

We have not configured a server. So, let’s configure a server first.

Click on Configure required setting

It will open a screen to create a new server

Step 5

Enter Server details to configure Server.

It will ask for following information. After filling the information click on Select button.

• Server Name = Name of the server
• Server Admin Login = Name for server admin login
• Password = Set Password for Server
• Location = Select Data center

Step 6

Select Pricing Tier and click on Create button.

Step 7

Our database has been created successfully.

Step 8

Now, it’s time to open the Azure SQL Database in SSMS.

For that if we need server information Select our created database > From overview we will get all the details.

Step 9

Open SQL Server Management Studio

Enter the details.

• Server Name = Server which we created on Azure Portal
• Username = Name of the Server Admin which we have set in previous step 5.
• Password = Password for the server which we set in Step 5

Conclusion

This is how we can create our first blank database in Azure SQL.