Q: What is AWS Launch Wizard for SQL Server?
A: AWS Launch Wizard for SQL server is a console-based way to quickly and easily size, configure, and deploy self-managed high availability solutions on SQL Server on Amazon EC2 without you having to identify and provision individual AWS resources.
Q: Why should I use AWS Launch Wizard?
A: AWS Launch Wizard offers you an easy way to deploy and optimize cost for SQL Server applications. Instead of selecting and configuring separate infrastructure services, you go through a few steps in the AWS Launch Wizard and it deploys a ready-to-use application on your behalf. It reduces the time you need to spend on investigating how to assemble, cost, provision, and configure your SQL Server application on AWS. AWS Launch Wizard determines the right instance type, EBS volumes, and other resources to match your application requirements such as performance, memory, and bandwidth. You also have the ability to modify the recommended defaults. AWS Launch Wizard provides you with custom CloudFormation templates that can serve as a baseline for your subsequent application deployments.
Q: What versions of SQL Server can I deploy through the AWS Launch Wizard?
We support installation of SQL Server 2016 and 2017 Standard and Enterprise Editions on Windows Server 2019, 2016 and 2012 R2.
Q: How do I get started with the AWS Launch Wizard for SQL Server?
A: You can use AWS Launch Wizard in the following three steps:
- Step 1: Launch AWS Launch Wizard from https://aws.amazon.com/launchwizard or from the AWS console. Select SQL Server Always On from the options menu.
- Step 2: Enter your specifications for SQL Server Always On such as application name, SQL Server version, number of nodes, throughput, high-availability cluster etc. Additionally, there will be questions about your Active Directory and VPC preferences.
- Step 3: AWS Launch Wizard recommends the most appropriate resources based on your input specifications and shows you an estimated cost. You can edit these resources to suit your preferences and get an updated cost estimate. Once you finalize the resources, AWS Launch Wizard deploys them and configures your application.
Post deployment, you can use the EC2 Console to access your deployed resources. Similarly, you can manage your application through AWS Systems Manager, monitor it through Amazon CloudWatch, and govern IT policies through AWS Service Catalog.
Q: How much does AWS Launch Wizard for SQL Server cost?
A: There is no additional charge for using AWS Launch Wizard. You only pay for the AWS resources that are provisioned for running your application (for example, Amazon EC2 instances and EBS volumes).
Q: Can I use AWS Launch Wizard for SQL Server to modify application resources after deployment?
A: No. Currently, for modifying resources post-deployment, you will have to use the service console of that resource. For example, modify EC2 instances through the EC2 Console.
Q: If I modify application resources after deployment, would AWS Launch Wizard for SQL Server detect those changes?
A: No. AWS Launch Wizard is a provisioning tool and does not manage the application lifecycle beyond the initial deployment. To make changes or track the status of resources after they have been provisioned, you can use other AWS services such as Systems Manager and the EC2 Console.
Q: Can I delete the resources provisioned through AWS Launch Wizard for SQL Server after deployment?
A: Yes. You have the option to delete your provisioned resources from the summary screen on AWS Launch Wizard.
Q: How do I patch and monitor the application post deployment?
A: You can patch the application resources through AWS Systems Manager and monitor it through Amazon CloudWatch.
Q: How do I discover applications that I have deployed through AWS Launch Wizard for SQL Server in the past?
A: Each time you launch AWS Launch Wizard, it shows you a historical list of applications that you deployed using the AWS Launch Wizard. When you click on an existing application, the wizard takes you to its summary page, which contains access information such as IP address and resource group name.
Q: What IAM role do I require for using AWS Launch Wizard for SQL Server?
A: For the very first access on an account, you will need a one-time setup of the IAM user policy as described in the documentation. Then you can continue to use these user credentials to log in to the Launch Wizard.
Q: What IAM policy does AWS Launch Wizard for SQL Server carry during deployment?
A: AWS Launch Wizard assumes the IAM role to create, describe, tag, modify, or delete resources on your behalf during deployment.
Q: What are all the regions where AWS Launch Wizard for SQL Server is available?
A: AWS Launch Wizard is available in the following AWS Regions: US East (N. Virginia), EU (Frankfurt), South America (Sao Paulo), US West (N. California), Asia Pacific (Mumbai), US East (Ohio), EU (Ireland), Asia Pacific (Tokyo), US West (Oregon), Asia Pacific (Singapore), Asia Pacific (Sydney), EU (London), Canada (Central), Asia Pacific (Seoul), EU (Stockholm)
Q: How is AWS Launch Wizard for SQL Server different from AWS CloudFormation?
A: AWS Launch Wizard leverages AWS CloudFormation and provides a deployment option to customers who prefer guided UI-driven experience. AWS Launch Wizard provides you a guided point-and-click experience to deploy applications. You answer a few high-level questions about your application requirements on the console, and then AWS Launch Wizard handles the end-to-end sizing, cost estimation, provisioning and configuration of your application. CloudFormation allows you to programmatically deploy resources on AWS by manual code creation.
Q: How is AWS Launch Wizard for SQL Server different from AWS Quick Starts?
A: AWS Quick Starts are deployment accelerators that reduce hundreds of manual procedures into a select few that allow you to quickly create deployments through a command line interface. Providing another way of provisioning applications, AWS Launch Wizard offers you a complete UI-driven guided experience for deploying production-ready applications on AWS with added benefits of resource sizing, customizable deployments, application configuration and cost estimation.
Q: Can I bring my own SQL Server licenses (BYOL) for deployments through AWS Launch Wizard?
A: Yes. AWS Launch Wizard enables you to bring your own SQL Server licenses through the use of custom Amazon Machine Images (AMIs).
Q: How can I track the SQL Server licenses that I am deploying through AWS Launch Wizard for SQL Server?
A: You can use AWS License Manager to manage licenses in AWS and on-premises servers from software vendors such as Microsoft. AWS License Manager lets administrators create customized licensing rules that emulate the terms of their licensing agreements, and then enforces these rules when an instance of EC2 gets launched from the AWS Launch Wizard.
Q: Does the SQL Server Always On availability group application deployed through AWS Launch Wizard for SQL Server get joined to my Active Directory (AD) domain?
A: Yes. When deploying SQL Server Always On through AWS Launch Wizard, we ask you for your AWS Managed Microsoft AD domain credentials and domain join the application to your AWS Managed AD account. If you don’t have an existing AWS Managed Microsoft AD account, Launch Wizard provides you the option to create one during deployment. You can also domain join your SQL Server deployment to your on-premises Active Directory.
Learn how to get started with AWS Launch Wizard. Visit the Documentation Page.
Instantly get access to the AWS Free Tier.
Get started building with AWS Launch Wizard in the AWS Management Console.