/quickstart-microsoft-sql

AWS Quick Start Team

Primary LanguagePowerShellApache License 2.0Apache-2.0

quickstart-microsoft-sql

SQL Server on AWS with Windows Server Failover Clustering and Always On Availability Groups

AWS provides a comprehensive set of services and tools for deploying Microsoft Windows-based workloads on its highly reliable and secure cloud infrastructure. This Quick Start implements a high availability solution built with Windows Server and SQL Server running on Amazon EC2, using the Always On Availability Groups feature of SQL Server Enterprise edition.

The deployment includes Windows Server Failover Clustering (WSFC) and clustered SQL Server 2014, 2016, or 2017 instances on the AWS Cloud. The Quick Start includes a rich set of configuration options for SQL Server, Active Directory, and the WSFC cluster, including SQL Server version and licensing, tenancy options, and a choice of two Active Directory implementations: You can use AWS Directory Service for Active Directory, or manage the EC2 instances for Active Directory yourself.

The AWS CloudFormation templates included with the Quick Start automate the following:

  • Deploying SQL Server into a new VPC
  • Deploying SQL Server into an existing VPC that includes Remote Desktop Gateway, NAT gateways, and Active Directory Domain Services

You can also use the AWS CloudFormation templates as a starting point for your own implementation.

Quick Start architecture for SQL Server on AWS

For architectural details, best practices, step-by-step instructions, and customization options, see the deployment guide.

To post feedback, submit feature ideas, or report bugs, use the Issues section of this GitHub repo. If you'd like to submit code for this Quick Start, please review the AWS Quick Start Contributor's Kit.