Microsoft SQL Server AlwaysOn on EC2 workshop


In this workshop we will be configuring and deploying a 2-node SQL Server 2019 cluster. Once the cluster has been created, we will be creating an AlwaysON availability group using a sample database backup.

Pre-provisioned resources in this workshop:

  • AWS Directory Service for Microsoft Active Directory
  • 2x SQL Server 2019 on Windows Server 2019 (domain-joined)
  • 1x Windows Server 2019 jumpserver/bastion host (domain-joined)

By the end of this workshop, you’ll be able to:

  • Familiarize yourself with the AWS console, and navigate through the different services used in this workshop
  • Use existing and familiar tools to manage SQL Server within AWS
  • Setup and configure a MSSQL AlwaysON Cluster within AWS

You can reset the checked progress at anytime by clicking on the Clear History link in the left navigation menu