Tuesday, 26 July 2016

Step by Step Install Windows SQL 2016 EnterPrise on Azure Portal

Step By Step Install SQL Server 2016 on MS windows server 2012 R2
Today we are showing you about how to install SQL server 2016 Enterprise Virtual machine using Azure
We are creating with our Azure subscription, if you don't have an Azure subscription, you can create a free account  in just a couple of minutes.
  • Login to the Azure portal site using your subscription id and password
  • Once login you will be on Portal page of Azure.
  • Click on new>Virtual machines>Select server
  • Choose the VM image from the marketplace
Currently we are creating Virtual SQL 2016 server (Using windows server 2012 R2 Datacenter)
  • On the Hub menu, click New > Virtual Machines > Windows SQL 2016  Enterprise on Windows server 2012 R2
  • On the SQL server 2016 Enterprise page, under Select a deployment model, verify that Resource Manager is selected. Click Create.
Install the MS SQL server 2016 Enterprise virtual machine using MS windows 2012 R2
After you select the image, you can use Azure's default settings for most of the configuration and quickly create the virtual machine.
  • On the Basics blade, enter a Name for the virtual machine. The name must be 1-15 characters long and it cannot contain special characters.
  • Enter a User name, and a strong Password that will be used to create a local account on the VM. The local account is used to log on to and manage the VM.
The password must be between 12-123 characters long and have at least one lower case character, one upper case character, one number, and one special character.
  • Select an existing Resource group or type the name for a new one. Type an Azure datacenter Location such as West US.
  • When you are done, click OK to continue to the next section.
Screenshot that shows the settings on the Basics blade for configuring an Azure VM
  • Choose a VM size and then click Select to continue.
  • On the Settings blade, you can change the storage and networking options. For a first virtual machine, you can generally accept the default settings. If you selected a virtual machine size that supports it, you can try out Premium Storage by selecting Premium (SSD) under Disk type. When you are done making changes, click OK.
  • Specify Server settings
  1. Storage account.
  2. Network.
  3. Subnet.
  4. Public IP address.
  5. Network security group.
  6. Monitoring and Availability
  • Click OK to continue.
  • Specify SQL Server settings
  1. SQL connectivity.
  2. SQL Port
  3. Storage configuration
  4. Automate patching
  5. Automated backup
  6. Azure Key Valut integration


  • Click OK to continue.
  • Review your configuration in Summary page and click OK to deploy SQL Server 2016 on Azure VM.

  • Click Summary to review your choices. When you're done, click OK.
  • While Azure creates the virtual machine, you can track the progress under Virtual Machines in the hub menu.
  • Once click on create button, IT will start creating the server
  • It will show the deployment running status at left corner, so now wait till the completion
  • Once installation done it will completion message
  • Connect to the virtual machine and log on


No comments:

Post a Comment