Create Configure and Use SQL Server Database using Microsoft Azure

create configure SQl server microsoft azure 4

In this Article I had explained how to create, configure and SQL Server database in Microsoft Azure.
Open Microsoft Azure Portal.

Logged in with your subscription Microsoft account
In your portal
Click New -> SQL database

create database in azure
create database in azure

Click Add
Provide the database name and select the subscription of your account
Create a new resource group



create database in microsoft azure
create database in microsoft azure

Click on the server to create a new server

 microsoft azure configure sql server database

microsoft azure configure sql server database

Provide the Server name of your newly creating Database Server
Provide the login username and password to access the database server
Pick your server location
Click Select to create a new SQL server
SQL Elastic pool by default: N0
SQL elastic pool: SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases
Pick the pricing tier -> In my scenario am picked Basic 2GB

steps to create sql database in microsoft azure
steps to create sql database in microsoft azure

Collation By Default
Click Create


create database in azure sql server
create database in azure sql server

So now the SQL server database has been created successfully and ready to Go
Now will connect it from local SQL Server Management Studio
Click Connect.

azure sql database tutorial
azure sql database tutorial

Provide the server name “vinodh.database.windows.net”
Pick authentication type “SQL Sever authentication”
Provide the username and password
Click Ok and connection works successfully.


reate table in azure sql database
reate table in azure sql database

Created database has been shown inside the server
Now going to create a table inside the database for example
Query: Create table AzureDB(Sub_name varchar(50))

create sql database in azure
create sql database in azure

You can also get the connection string from azure portal to click on connection string option

how to create database in azure sql server
how to create database in azure sql server

Read some SharePoint tutorials below:

Now ready to go. Happy learning!…….


You May Also like the Following SharePoint Online Tutorials:

Leave a Reply