1. Prerequisite Features and Modules

As this workshop relies heavily on powershell on install and configure the cluster, we must make sure that the prerequiste windows features and modules are properly installed:

  1. Within the jumpserver, open up Powershell ISE by right-clicking it and running it as Administrator:


#Installs the 'Failover Cluster' as well as the AD powershell module windows features remotely to both EC2SQL1 and EC2SQL2 servers

Install-WindowsFeature -Name RSAT-AD-Powershell,Failover-Clustering -IncludeManagementTools -ComputerName "EC2SQL1"
Install-WindowsFeature -Name RSAT-AD-Powershell,Failover-Clustering -IncludeManagementTools -ComputerName "EC2SQL2"

#Installs the the various AD and cluster related remote managmeent tools into the jumpserver
Install-WindowsFeature -Name RSAT-Clustering,RSAT-ADDS-Tools,RSAT-AD-Powershell,RSAT-DHCP,RSAT-DNS-Server -ComputerName "EC2Jump"

#Installs the required powershell modules from the Powershell Gallery (external) locally into jumpserver
Install-module -Force Sqlserver,AWSPowerShell,dbatools
  1. When first opening up Powershell ISE, make sure to open up the Script Pane, where you will be pasting the scripts

  2. Once executed, you should see an output below (Since most of these features and modules have already been pre-installed, there should be no changes needed): -

If you want to use the scripts in this workshop, to setup and configure Windows clusters outside of this workshop, then these features and modules are required