In this article, I am going to show what is SQL Server VM
and what are the steps to create a SQL Server VM.
SQL
Server on Azure virtual machines enables you to use full
versions of SQL Server in the Cloud without having to manage any on-premises
hardware.
Below are some advantages we can have with SQL Server VM.
- Automated updates
- Automated backups
- High availability
- Performance
Now
we will learn Step By Step, how to create a new SQL Server VM
Step 1: Sign in your Azure Portal.
https://portal.azure.com
In Left Side Menu -> Select All Services -> Type
AZURE SQL in Search box -> Now Select AZURE SQL
Image 1.
Now Click on + Button.
Image 2.
Now Select Free
SQL Server License: SQL Server 2017 Developer on Windows Server 2016 From
the Drop Down List.
Image 3.
After selecting Click on Create Button.
Enter Basic Details.
Image 4.
Enter Account related information.
Image 5.
Image 6.
Image 7.
Image 8.
Image 9.
Now validate all your settings.
Image 10.
Click on Create. It will take some time.
Image 11.
Now VM deployment successful.
Image 12.
Resource is ready to use.
We can connect SQL Server by using below IP address and
UserId/Passwords which we entered while creating VM.
Image 13.
Image 14.
Now click on Connect to RDP.
Image 15.
It will download a RDP file click on it and connect.
Image 16.