SqlServer 2016 Virtual Machine Setup In Microsoft Azure.

Azure VMs provide a way to move your on-premises SQL Server workloads and applications to the Cloud.

There are many reasons that you might choose to host your data in Azure. If your application is moving to Azure, it improves performance to also move the data. But there are other benefits. You automatically have access to multiple data centers for a global presence and disaster recovery. The data is also highly secured and durable.

Find step-by-step guidance for this process in the tutorial, Provision a SQL Server virtual machine in the Azure portal.

1.Login on azure portal by using your  Microsoft azure account. if you not have any azure account then you may use Microsoft azure trial.



2. look for virtual machines option from the left blade and and click on it.Now click “Add” option and select sqlserver virtual machine from all available images.A2.PNG

Now All available images will come in new pane and you have select sqlserver 2016 image.


3. Under Select a deployment model, verify that Resource Manager is selected. Resource Manager is the recommended deployment model for new virtual machines. Click Create.


Configure Virtual Machine

There are five important steps to configure the virtual machine as per below:


1.Configure Basic Settings:

Provide following information on basic configure tab:

  • Provide Unique Virtual Machine Name.
  • User name for the local administrator account on the VM.
  • Provide a strong Password.
  • Select Subscription what ever you have.
  • In the Resource group box, type a name for a new resource group. Alternatively, to use an existing resource group click Select existing.To know more about resource group.https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-overview
  • Select a Location for this deployment.
  • Click OK to save the settings.


2. Select Virtual Image Size:

There are lot of virtual images size available on azure portal. Initially most recommended images comes on screen and you can  select any other image size which is most appropriate for you.


3.Configure optional features:

On the Settings blade, configure Azure storage, networking, and monitoring for the virtual machine.A8.PNG

4.Configure sql server settings:

Sql server configurations is important section of virtual machine setup,here you have to configure various type of settings like Authentication,Network connectivity.

  • Public (internet) to allow connections to SQL Server from machines or services on the internet. With this option selected, Azure automatically configures the firewall and the network security group to allow traffic on port 1433.
  • Local (inside VM only) to allow connections to SQL Server only from within the VM.
  • Private (within Virtual Network) to allow connections to SQL Server from machines or services in the same virtual network.
  • If you require SQL Server Authentication, click Enable under SQL authentication.Under Sql authentication you have to specify username and password.

Here i am going with public network with Sql authentication.


5. Summary:

this is last step of virtual machine configuration and here you only have to review all the steps activity from step 1 to step 4.If all the things are good then click ok. Now your Sql Server machine setup is complete and ready to use.


Click again on virtual machine option in left blade of screen and now you can see your newly created sql server machine is listed.


Connect virtual machine with Remote Desktop

Use below steps to connect VM with remote desktop:

  • Click on your new SQL virtual machine. A Virtual machine blade displays your virtual machine details.
  • At the top of the Virtual machine blade, click Connect.
  • The browser downloads an RDP file for the VM. Open the RDP file.


Once you have opened .RDP file,you have to enter your username and password. These are the same username and password which was specified in Sql authentication.


Once you have entered correct username and password then you will navigate to your virtual machine.


After you connect to the SQL Server virtual machine, you can launch SQL Server Management Studio and connect with Windows Authentication using your local administrator credentials. If you enabled SQL Server Authentication, you can also connect with SQL Authentication using the SQL login and password you configured during provisioning.





Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s