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.