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.

 

Fig.7

 

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

Fig.8Fig.9

 

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

 

Fig.10

 

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

Fig.11

 

  • 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