Amazon Web Services offers you the flexibility to run Microsoft SQL Server for as much or as little time as you need. You can select from a number of versions of Microsoft SQL Server, as well as choose between running it on Amazon EC2 or Amazon RDS.

Using SQL Server on EC2 gives you complete control over every setting, just like when it’s installed on-premises. RDS is a fully managed service that takes care of all the maintenance, backups, and patching for you. To see what versions and editions are available, read below for EC2 and go here for RDS. Both EC2 and RDS have ways to bring your own license for SQL Server.

Webinar

Learn more

Getting Started with SQL Server 2016 on AWS

Thursday, August 25
12-1pm PT

Tom Staab
AWS Partner Solutions Architect

Brought to you by AWS »

SQL Server Express Edition 2008, 2008 R2, 2012, 2014, and 2016: An entry-level database product that enables small database applications. The maximum size of a database supported is 10 GB. This product is offered at no-additional cost over the base Microsoft Windows Server instance price on EC2.

SQL Server Web Edition 2008 R2, 2012, 2014, and 2016: A mid-level database product that is restricted to Web facing applications, and available at a low cost over the base Windows Server instance price on EC2. This product offers unlimited database size, easy manageability, and is suitable for small to large-scale Web applications.

SQL Server Standard Edition 2008, 2008 R2, 2012, 2014, and 2016: A higher-end database product that allows unrestricted use for building enterprise-scale Windows-based applications, and massively scalable websites. SQL Server Standard includes support for Mirroring, and is suitable for applications with High Availability needs.

SQL Server Enterprise Edition 2012, 2014, and 2016: A high-end, datacenter database product offers “AlwaysOn” high availability, in-memory performance, enterprise scalability, self-service business intelligence and robust data quality. SQL Server Enterprise Edition is suitable for demanding database and business intelligence requirements.

All versions of SQL Server integrate with Amazon Elastic Block Store (Amazon EBS), enabling you to take advantage of the persistence, performance, and reliability of Amazon EBS for all your databases. Click here to learn more about other database options with AWS. To find details on available AMIs please visit the Windows AMI page or the AMI Catalog.


If You Need:

Consider Using:

A relational database service with minimal administration

  • Amazon RDS for SQL Server, a fully managed service that offers SQL Server 2008 R2, 2012, and 2014 while offloading database administration tasks like managing backups, detecting failures and recovering and much more.

A relational database you can manage on your own

  • Your choice of relational AMIs on Amazon EC2 and EBS that provide scale compute & storage, complete control over instances, and more.
  • Amazon EC2 running Windows Server with your choice of several versions of Microsoft SQL Server offers you the flexibility to run a database server for as much or as little time as you need. All SQL Server versions that we offer integrate with Amazon EBS, enabling you to take advantage of the persistence, performance, and reliability of Amazon EBS for all your databases.

If you are new to AWS, you will need to create an AWS account before you can launch an Amazon EC2 or Amazon RDS instance.