You can configure Microsoft SQL Server on Amazon EC2 instances for high availability. SQL Server Always On availability groups offer high availability without the requirement for shared storage.

Deploy SQL Server Always On using Failover Cluster Instances (FCI) for instance-level protection. A single SQL Server instance is installed across Windows Server Failover Clustering (WSFC) nodes to ensure high availability and storage sharing.

There are four options for deploying FCIs on AWS: Amazon EBS Multi-Attach with NVMe reservations supports the creation of SQL Server FCIs with Amazon EBS io2 volumes as the shared storage on Windows Server failover clusters.

Jan 12, 2024 · In this blog post, we’ll walk you through creating a Microsoft SQL Server failover cluster on Amazon Web Services (AWS) with Amazon Elastic Block Storage (Amazon EBS) Multi-Attach, using the recently introduced Amazon EBS Multi-Attach on io2 volumes with persistent reservations feature.

To create an SQL Server Always On availability group cluster in the AWS Cloud, configure two secondary IPs for each cluster node elastic network interface. Then, use Remote Desktop Protocol (RDP) to connect as a Domain Administrator account to the cluster node instances.

May 9, 2022 · For this article, I will share with you how you can launch your SQL Server Failover Cluster instance complete with shared storage on Amazon FSx via the AWS Launch Wizard. SQL Server failover cluster instance configuration offers a highly available database engine platform for your relational database needs.

Jun 15, 2023 · Through this document we describe how to configure Windows Server Failover Clustering (WSFC) on AWS Cloud to achieve resilience for MS SQL Server running on EC2 Instances. A virtual private cloud (VPC) configured with public and private subnets across two availability zones. This provides the network infrastructure for SQL Server deployment.

Apr 8, 2021 · In this article, we offer a step-by-step guide on how to set up a SQL Server Always On availability group on AWS EC2 Instances. Mohamed is a cloud infrastructure expert with experience in engineering and implementation in AWS and Azure. He currently works as a Cloud Infrastructure Architect at Amazon Web Services.

Feb 25, 2025 · Due to collation and framework restrictions, the recommended way to set up a SQL cluster on AWS—via RDS—was not an option. Instead, we opted for a SQL Failover Cluster running on EC2 Windows Server instances. The AWS reference setup is mostly accurate and helpful, but one crucial tweak was needed to get the cluster up and running.

Jun 16, 2022 · In this post, we’ll show you how Amazon EC2 Dedicated Hosts and AWS License Manager can be used to design a highly-available Microsoft SQL Server architecture while saving costs by bringing your own licenses. You will understand how License Manager integrates with Dedicated Hosts to reduce management overhead.