How to Create SQL Databases in Microsoft azure.

Azure SQL Database is a cloud-computing database service (Database as a Service), that is offered by Microsoft Azure Platform which helps to host and use a relational SQL database in the cloud without requiring any hardware or software installation.


  • Login to azure portal.
  • Click on All Services.
  • Select SQL Databases.


Fig 1


  • Click on Create.


Fig 2


  • On Basics tab provide the following values:-


  • Subscription: An Azure subscription grants you access to Azure services.
  • Resource group name: A resource group is a collection of resources.
  • Provide the Database name.
  • Click on Create New or Select existing Server.


Fig. 3

Fig. 4


  • At New Server window appear,Provide the Server name.
  • Provide the Server admin login name & Password.
  • Select Location.
  • Click on OK.
  • Then,Select Compute + Storage plan as per requirement.
  • Click on Next Networking.


Fig. 5


  • Now Select an option for Configure network access & connectivity for server.
  • Click on Next Security.


Fig. 6


  • Protect your data using azure defender for SQL.
  • Click on Next additional settings.




  • Select Data source  for sql database.
  • Select Database collation.
  • Set the maintenance window for sql database.
  • Click on Tags.



  • On Tags Tab provide the tag name and value for SQL Databases.
  • Click Next on Review + Create.




  • If you get a message “Validation passed”.
  • Then click on Create.



  • After some time, you will see a message as “Your deployment is ready”.
  • Click on “Go to resources” & You can see that the SQL Database is there with the name we provide.

Leave a Reply