Creating SQL Server Virtual Machine in Azure ( IaaS)

Hi Everyone in this article I have shared how to create a SQL Server 2016 Virtual machine using Azure as an IaaS solution.

Aim :-

(1) Create a SQL server VM and configure it properly.

(2) Do RDP of the VM which you created and check whether you can access it or not.

(3) Install SSMS( SQL Server Management Studio ) to connect to the SQL server.

Quick start steps :-

• Go create a resource and in the market space type SQL server 2016.

• Then it allows you to create the Virtual Machine.
• Basic Configuration

Then either you can create a new Resource group or go with an existing one. Here I have preferred existing resource group.

• Size Configuration :-

In this section we will be deciding the size and it's related configuration for our SQL server Virtual machine.

I have selected the bas:ic size as per my requirements.

• Configuration settings :-

Here we will be deciding the valuable parameters starting from availability set ,Network security group,Disk type ,Virtual networks & e.t.c.

Since it is a SQL server so we have to enable port 1433,1401 both inbound and outbound by creating a rule.

We also need to allow port 3389 for RDP.

SQL Server Settings :-

Now here we have to do some necessary changes like

SQL Connectivity :- Public

Port :- 1433 (SQL)

SQL Authentication :- Enabled

Login Name & Password :- xxxxxxxxx

Now you have created a SQL Server 2016 VM.

Next step is to take RDP of the VM and check whether it is accessible or not.

So here in below I have taken the RDP of my existing SQL Server Virtual Machine.

Copy the Public ip i.e. 52.172.132.174 and do MSTSC.

So from this step you get a clear picture that the SQL Server Virtual Machine which you have created is accessible.

Now the very last step is whether the SQL Server is accessible via SSMS or not.

To test this case you need install SSMS using the link given below.

 Download SQL Server Management Studio 17.9 (no previous version of SSMS 17.x is required on the computer)

 Download SQL Server Management Studio 17.9 Upgrade Package (upgrades 17.x to 17.9; a previous version of SSMS 17.x is required on the computer)

Once you have Installed and open the SSMS then it will ask for the credentials and in that process in place of the server name you should give the IP Address along with the SQL port number .

Ex :- xx.xx.xx.xx,1433

That's all you need to connect your SQL Server with SSMS.

I hope this article will help you to deal this entire Quick start step by step.