SQL Server with WSFC on AWS
SQL Server with WSFC Quick Start

Document Revisions

Date Change Location
December 2017

Added support for SQL Server 2017; deprecated SQL Server 2012.

Added instructions for setting up permissions for the cluster object.

Template updates and changest throughout guide

Set up permissions

August 2017 Refactored templates with submodules following Quick Start best practices, and added support for:
  • AWS Directory Service for Microsoft AD (by default)

  • SQL Server 2016 and license-included AMI provided by Amazon

  • Three tenancy options (default, dedicated, dedicated hosts)

  • Choice of two or three Availability Zones

  • Choice of two SQL nodes plus dedicated file share witness, or three SQL nodes

  • Customizable EBS volume types (gp2, io1) and adjustable IOPS (for io1)

  • New R4 instance types

Template updates and changes throughout guide
September 2015 In the sample template, changed the default type for Active Directory and RD Gateway instances from m3.xlarge to m4.xlarge for better performance and price. Template parameters
April 2015 Updated the storage configuration on the WSFC nodes. Storage on the WSFC Nodes
March 2015 Optimized the underlying Amazon VPC design to support expansion and to reduce complexity. Architecture diagram and template updates
November 2014 In the sample templates, changed the default type for NATInstanceType to t2.small to support the EU (Frankfurt) region. Template parameters
July 2014 Initial publication


This deployment guide is provided for informational purposes only. It represents AWS's current product offerings and practices as of the date of issue of this document, which are subject to change without notice. Customers are responsible for making their own independent assessment of the information in this document and any use of AWS's products or services, each of which is provided "as is" without warranty of any kind, whether express or implied. This document does not create any warranties, representations, contractual commitments, conditions or assurances from AWS, its affiliates, suppliers or licensors. The responsibilities and liabilities of AWS to its customers are controlled by AWS agreements, and this document is not part of, nor does it modify, any agreement between AWS and its customers.

The software included with this guide is licensed under the Apache License, Version 2.0 (the "License"). You may not use this file except in compliance with the License. A copy of the License is located at http://aws.amazon.com/apache2.0/ or in the "license" file accompanying this file. This code is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

On this page: