Showing posts with label Azure SQL Server. Show all posts
Showing posts with label Azure SQL Server. Show all posts

Saturday, May 30, 2020

Creating SQL Server on Azure Cloud

Today i created an SQL Server Database on Azure cloud, Now a days many organisations are increasingly moving to cloud on various databases. I thought of trying SQL Server today and am still exploring all the options provided in azure for SQL server.

I captured some screenshots for the same and can outline the process:

In azure portal go to Databases and click on SQL Servers, the click create.
  
     The below screen will appear, Provide the resource group, Database Name and Server name. To create a server click on Create new and a new screen will appear 


In this screen provide server-name,username,password,location 

            

 You will need to check storage/compute option, do click and check how many DTU's and Disk space is required since you will be charged for the same. I chose a basic one for my testing 



Once done next page will be to validate network connectivity, i clicked on public endpoint to allow my machine to access the database (this, myip needs to be configured in firewall setting as well) 



Next step is Data source - if you want to create a blank, sample database or import from an existing one. i chose to create sample DB.



At the end click review and create and the deployment will take place, this takes a few minutes.


Once Done we can connect to your database using query editor and giving username/password that was given during DB Creation.