Menu
SQL Server with WSFC on AWS
Quick Start Reference Deployment Guide

SQL Server on the AWS Cloud: Quick Start Reference Deployment

Using Windows Server Failover Clustering (WSFC) and SQL Server Always On Availability Groups

Deployment Guide

Santiago Cardenas and Jay McConnell — Amazon Web Services

July 2014  (last update: August 2017)

This Quick Start deployment guide discusses architectural considerations and configuration steps for deploying a Microsoft Windows Server Failover Clustering (WSFC) cluster and a SQL Server Always On Availability Group on the Amazon Web Services (AWS) Cloud. It also provides links for viewing and launching AWS CloudFormation templates that automate the deployment.

Note

Always On Availability Groups is a feature supported by SQL Server Enterprise edition. Running WSFC nodes in the same subnet is currently not supported on the AWS Cloud.

This guide is for IT infrastructure architects, administrators, and DevOps professionals who are planning to implement or extend their WSFC and SQL Server workloads on the AWS Cloud.

This Quick Start supports SQL Server versions 2012, 2014, and 2016.

The following links are for your convenience. Before you launch the Quick Start, please review the architecture, configuration, network security, and other considerations discussed in this guide.

Note

You are responsible for the costs related to your use of any AWS services used while running this Quick Start reference deployment. See the pricing pages of the AWS services you will be using for full details.

  • If you have an AWS account, and you're already familiar with AWS services, SQL Server, and WSFC, you can launch the Quick Start to build the architecture shown in Figure 1 in a new or existing virtual private cloud (VPC). The deployment takes approximately 3 hours. If you're new to AWS or to SQL Server, please review the implementation details and follow the, see the step-by-step instructions provided later in this guide.

     

         

     

  • If you want to take a look under the covers, you can view the AWS CloudFormation templates that automate the deployment.

     

         

About Quick Starts

Quick Starts are automated reference deployments for key workloads on the AWS Cloud. Each Quick Start launches, configures, and runs the AWS compute, network, storage, and other services required to deploy a specific workload on AWS, using AWS best practices for security and availability.

On this page: