How do I create an SQL Server Always On availability group cluster in the AWS Cloud?

Short description

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. Finally, create a two-node Windows cluster and SQL Server Always On availability groups.

You can also use AWS Launch Wizard to create an SQL Server Always On availability group deployment. The Launch Wizard identifies the AWES resources to provision the SQL Server databases automatically based on your use case. For more information, see What is AWS Launch Wizard for SQL Server?

Resolution

To deploy a SQL Server Always On availability groups, see the Deploy SQL Server Always On availability groups (AG) section of Deployment options.

Related information

Best practices and recommendations for SQL Server clustering on Amazon EC2

AWS Launch Wizard

Configure a listener for an Always On availability group on the Microsoft website