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


Q. I encountered a CREATE_FAILED error when I launched the Quick Start.

A.If AWS CloudFormation fails to create the stack, we recommend that you relaunch the template with Rollback on failure set to No. (This setting is under Advanced in the AWS CloudFormation console, Options page.) With this setting, the stack’s state will be retained and the instance will be left running, so you can troubleshoot the issue. (You'll want to look at the log files in %ProgramFiles%\Amazon\EC2ConfigService and C:\cfn\log.)


When you set Rollback on failure to No, you'll continue to incur AWS charges for this stack. Please make sure to delete the stack when you've finished troubleshooting.

The following table lists specific CREATE_FAILED error messages you might encounter.

Error message Possible cause What to do
API: ec2: RunInstances Not authorized for images: ami-ID The template is referencing an AMI that has expired. We refresh AMIs on a regular basis, but our schedule isn’t always synchronized with AWS AMI updates. If you get this error message, notify us, and we’ll update the template with the new AMI ID.

If you’d like to fix the template yourself, you can download it and update the Mappings section with the latest AMI ID for your region.

We currently do not have sufficient r4.2xlarge capacity in the AZ you requested The WSFC node requires a larger instance type Switch to an instance type that supports higher capacity, or complete the request form in the AWS Support Center to increase the Amazon EC2 limit for the instance type or region. Limit increases are tied to the region they were requested for.
Instance ID did not stabilize You have exceeded your IOPS for the region. Request a limit increase by completing the request form in the AWS Support Center.
System Administrator password must contain at least 8 characters The master password contains $ or other special characters. Change the password for the domain administrator or SQL Server service account, and then relaunch the Quick Start.

The password must be at least 8 characters, consisting of uppercase and lowercase letters and numbers. Avoid using special characters such as @ or $.

For additional information, see Troubleshooting AWS CloudFormation on the AWS website. If the problem you encounter isn’t covered on that page or in the table, please visit the AWS Support Center. If you’re filing a support ticket, please attach the install.log file from the master instance (this is the log file that is located in the /root/install folder) to the ticket.

Q. I encountered a size limitation error when I deployed the AWS CloudFormation templates.

A. We recommend that you launch the Quick Start templates from the location we’ve provided or from another S3 bucket. If you deploy the templates from a local copy on your computer, you might encounter template size limitations when you create the stack. For more information about AWS CloudFormation limits, see the AWS documentation.