Thursday, 8 December 2016

Install Windows SQL 2016 EnterPrise on Azure Portal (Cloud) step by step with screen shots

Today we are showing you about how to install SQL server 2016 Enterprise Virtual machine using Azure. Cloud server is giving facility to us host our machine on the same. Azure hosted machine speed and performance will be much better than hosted server also the Net speed on azure servers will be faster than all time.
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 to the azure portal dashboard will be coming on the page
  • Now Click on new option from Virtual machines then Select server same as below screen shot:
  • Choose the VM image from the marketplace or here as mentioned above
Currently we are creating Virtual SQL 2016 server (Using windows server 2012 R2 Datacenter)
  • On the Hub menu, click New  and select  Virtual Machines then select Windows SQL 2016  Enterprise on Windows server 2012 R2( windows server will be 2012 now 2016 already release so you can go ahead with this also)
  • On the SQL server 2016 Enterprise page, under Select a deployment model, verify that Resource Manager is selected. Click Create to create the same

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.
  • Few of tips are here: On the Basics blade, enter a Name for the virtual machine. As per azure policy the name must be 1-15 characters long and it cannot contain special characters.
  • User name assign which going to use 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.
  • 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, we can generally accept the default settings. If we selected a virtual machine size that supports it, we can try out Premium Storage by selecting Premium (SSD) under Disk type. When we are done making changes, click OK.
  • Specify Server settings
    • Storage account
    • Network.
    • Subnet.
    • Public IP address.
    • Network security group.
    • Monitoring and Availability
  • Click OK to continue.
  • Specify SQL Server settings
  • SQL connectivity.
  • SQL Port
  • Storage configuration
  • Automate patching
  • Automated backup
  • Azure Key Vault integration
  • Click OK to continue.
  • Review your configuration in Summary page and click OK to deploy SQL Server 2016 on Azure VM before going for finish the same
  • 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