Domain Controller – JBSDC

-> Below Azure Virtual Machine will be provisioned to be used as a Domain Controller. I have allowed In-Bound port 3389 for RDP as this is a Lab setup.

-> Disks Tab,

-> Networking Tab. Make sure a Standard SKU is selected for Public IP Address.

-> Tabs “Management”, “Advanced” and “Tags” are default in my case. Click “Create”,

Database Server – JBSAG1

-> Search for “SQL Virtual Machine” on Azure portal. Please note that I am selecting a “Free SQL Server License: SQL 2019 Developer Edition” as this is a lab. In reality you will need to utilize an enterprise edition.

-> Selecting an Image as mentioned here will have additional SQL Server components such as Analysis and Integration Services. You can either disableuninstall them if you don’t use or You can provision an Azure Virtual machine and then Install SQL Server on it which will allow you to select only required components.

-> Disks Tab,

-> Networking Tab. Make sure a Standard SKU is selected for Public IP Address.

->Tabs “Management” and “Advanced” are default in my case.

-> Tab “SQL Server Settings”. Click on “Change Configuration” under storage,

-> Please select appropriate settings to suit your performance requirement. In my case as this is a lab, I am utilizing a single disk for both data and log file and also selecting a smaller 64GB disk,

->Tab “Tags” is default in my case.

Database Server – JBSAG2

-> Follow the same method and provision an Azure virtual machine named JBSAG2 same as JBSAG1.

Database Server – JBSAG3

-> Search for “SQL Virtual Machine” on Azure portal. Please note that I am selecting a “Free SQL Server License: SQL 2019 Developer Edition” as this is a lab. In reality you will need to utilize an enterprise edition.

-> Selecting an Image as mentioned here will have additional SQL Server components such as Analysis and Integration Services. You can either disable\uninstall them if you don’t use or You can provision an Azure Virtual machine and then Install SQL Server on it which will allow you to select only required components.

-> Disks Tab,

-> Networking Tab. Make sure a Standard SKU is selected for Public IP Address.

->Tabs “Management” and “Advanced” are default in my case.

-> Tab “SQL Server Settings”. Click on “Change Configuration” under storage,

-> Please select appropriate settings to suit your performance requirement. In my case as this is a lab, I am utilizing a single disk for both data and log file and also selecting a smaller 64GB disk,

->Tab “Tags” is default in my case.

More articles on this Series,

-> Always On Availability Group Configuration on Azure IaaS Virtual Machine utilizing Multi Subnet
-> Always On Availability Group Environment on Azure IaaS Virtual Machine Introduction – Part1
-> Configure appropriate Virtual Network and Subnet for Azure IaaS Virtual Machine – Part2
-> Configure Domain Controller and Windows Cluster on appropriate Azure IaaS Virtual Machine – Part4
-> Configure Azure Load Balancer – Part5
-> Configure Always On Availability Group with Listener – Part6

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.