This AWS Solution builds a highly available Microsoft SQL Server environment, which includes Microsoft Windows Server and SQL Server running on Amazon Elastic Compute Cloud (Amazon EC2), on the Amazon Web Services (AWS) Cloud. It uses AWS Systems Manager Automation, AWS CloudFormation, and Windows PowerShell Desired State Configuration (DSC) to deploy a multi-node SQL Always On Failover Cluster Instance (FCI) and Amazon FSx for Windows File Server.

This architecture uses Windows Server Failover Clustering (WSFC) to increase application availability. WSFC provides infrastructure features that complement the high availability and disaster recovery scenarios supported in the AWS Cloud.

This solution is for IT infrastructure architects, administrators, and DevOps professionals who want to deploy and customize their own SQL Server environment. If you want a more guided deployment option, consider AWS Launch Wizard.

https://aws.amazon.com/solutions/implementations/microsoft-sql-fci-fsx/