How to configure Enterprise Edition of SQL Server 2016 on Azure Virtual Machine
In this article, we will configure Microsoft Enterprise Edition of SQL Server 2016 on Azure Virtual Machine (VM).
SQL Server 2016 Enterprise Edition is the most powerful and popular SQL Server version. It comes with many features like Always Encrypted, Row Level Security (RLS) etc. This blog will guide you step-by-step to configure SQL Server 2016 Enterprise Edition on Azure Virtual Machine.
Virtual machines are isolated compute instances running on shared physical server hardware. They look, feel, and function much like a physical computer that you would own. You can install almost any software application or service that runs on a Windows or Linux operating system, run scripts to automate common tasks, set up scheduled jobs to run backups or updates, disable unnecessary services; all without affecting other virtual machines running alongside them on the same hardware platform.
1: Create Microsoft Azure Virtual Machine
Log in to Azure Portal. Click on New->Compute->Virtual Machine->From Gallery->On the Basic configurations blade, click “SQL Server 2016 Enterprise (64-bit)” option and then click OK button.
2: Connect to Microsoft SQL Server 2016 Virtual Machine
Once the virtual machine is created successfully, you will see the following portal page which will display all required information like DNS name of VM, end point details, etc. We will be using these values later while deploying databases inside the created SQL Server instance. Now follow these simple steps to connect to the newly created SQL Server instance via RDP (Remote Desktop Protocol). We need our client machines with Windows OS installed so that we can connect to Azure VM remotely through Remote Desktop. Login to the virtual machine using RDP protocol. Right click on “SQL Server 2016 Enterprise (64-bit)” option and then click Connect button.
3: Configure SQL Server instance
The first screen will prompt you to select the authentication method so please select SQL Server Authentication option, enter local system account name and password of your choice. Click OK button. Once you are connected successfully to the SQL server instance, Configuration Manager will appear automatically for configuring some basic settings like service accounts etc for this SQL Server installation. We will be leaving all these options as per our requirement but if you want to know their meaning and best practices then kindly follow given link.
4: Deploy Database(s) inside Virtual Machine
For deploying database inside VM, follow given link. It will guide you through the whole process of creating database using SQL Server Management Studio (SSMS).
Deploy Database (s) inside Microsoft Azure Virtual Machine using PowerShell
Follow this step-by-step tutorial to deploy managed instances on Azure Virtual Machines.
5: All done! Now enjoy the power of SQL Server 2016 Enterprise Edition 🙂
I hope this blog was useful to configure Enterprise Edition of SQL Server 2016 on Azure Virtual Machine (VM). Stay tuned for more blogs and do not forget to like our Facebook page! jKool Work #WorkHard #PlayHard.
This article was originally posted at my TechNet Gallery page. If you liked it, please click like on the page which will help me gain confidence to write more articles.
1) Install SQL Server 2016 (Author: Venkat Reddy)
2) Deploy Database Instance on Microsoft Azure Virtual Machine (Author: Debo Dasoju)
3) Configure SQL Server Using Configuration Manager in SQL Server 2016 (Author: Thiyagaran S).
4) Create Database using SSMS – Step by Step Guide for Beginners! (Author: Uma Maheswara Rao G).
5) How To Connect Remotely to an Azure Virtual Machine Using RDP Protocol?
6) What is DACPAC and How to Use it? (Author: Pratik Chaudhari).
7) Tutorial: Configure a new Azure Virtual Network with a Site-to-Site VPN Connection using PowerShell (Author: Debo Dasoju)
8) What is Elastic IP Address and How to use it? (Author: Debo Dasoju).
9) Deploy SQL Server 2016 Database on Microsoft Azure Virtual Machine – Step by step guide for beginners! (Author: Ravi Kiran Vutukuri).
10) ALTER SERVER CONFIGURATION (Transact-SQL) – sys. Configurations Dynamic Management View (DMV)
To do so we need to provision a VM from Azure Marketplace and after that follow these steps:
1) Install software prerequisites for SQL Server
2) Install and configure Operating System
3) Upgrade Windows version
4) Enable Contained Databases
5) Add user accounts
6) Setup Endpoint
7) Test connectivity
8) Configure Always On Availability Group
9) Distributed Queries
10) Un Software Prerequisites
11) Clean up
We have successfully created two Availability Groups on SQL Server 2016 Enterprise R2.