Sold by: Amazon Web Services
SQL Server on AWS has lower TCO, higher performance, and the broadest and deepest capabilities. This SQL Server Amazon Machine Images (AMI) is built by Amazon Web Services (AWS) for use on Amazon EC2, the proven, reliable, and secure place for SQL Server.
Sold by: Amazon Web Services
Overview
The SQL Server Amazon Machine Images (AMI) is built, updated, and fully-patched by AWS within five business days of Microsoft's patch Tuesday (the second Tuesday of each month). Launching an instance from this AMI enables you to run the instance as a database server and saves you the effort to install SQL Server software. This AMI comes with following software and drivers including AWS Systems Manager, AWS CloudFormation, AWS Tools for Windows PowerShell, Network drivers, and Storage drivers.
You can use AWS Launch Wizard to easily size, configure, and deploy SQL Server applications on AWS. Launch Wizard for SQL Server supports both single instance and high availability deployments according to AWS and SQL Server best practices.
Highlights
- Built, updated, and fully-patched by AWS for SQL Server running on EC2.
- Preinstalled with AWS Systems Manager, AWS CloudFormation, AWS Tools for Windows PowerShell, and various drivers to make your management easier.
- Accelerate SQL Server single instance and high availability deployments with AWS Launch Wizard.
Details
Sold by
Delivery method
Delivery option
64-bit (x86) Amazon Machine Image (AMI)
Latest version
Operating system
Win2019 10
Pricing
This product is free. Subscriptions have no end date and can be canceled anytime.
Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator to estimate your infrastructure costs.
Additional AWS infrastructure costs
Type | Cost |
|---|---|
EBS General Purpose SSD (gp2) volumes | $0.10/per GB/month of provisioned storage |
Vendor refund policy
If you need to request a refund for software sold by Amazon Web Services, LLC, please contact AWS Customer Service. Web Support: bit.ly/1Q6bE3; Phone Support: bit.ly/MFEcTI
Legal
Vendor terms and conditions
Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .
Content disclaimer
Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Changes:
- AWSPowerShell v4.1.648
- SQL Server CUs installed:
- SQL_2016_SP3: GDR KB5042207
- Windows Security Updates current to September 10th 2024
Additional details
Usage instructions
Please visit this following page for more information on using Windows: http://aws.amazon.com/windows/
Resources
Vendor resources
Support
Vendor support
Free support is available through forums, technical documentation, and tutorials. Paid support is available.
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
Similar products
Microsoft SQL Server 2019 Enterprise on Windows Server 2016
By Amazon Web Services
SQL Server on AWS has lower TCO, higher performance, and the broadest and deepest capabilities. This SQL Server Amazon Machine Images (AMI) is built by Amazon Web Services (AWS) for use on Amazon EC2, the proven, reliable, and secure place for SQL Server.
Microsoft Windows Server 2022 Base
By Amazon Web Services
Amazon EC2 running Microsoft Windows Server is a fast and dependable environment for deploying applications using the Microsoft Web Platform. Amazon EC2 enables you to run compatible Windows-based solutions on AWS' high-performance, reliable, cost-effective, cloud computing platform.
Microsoft Windows Server 2019 Base
By Amazon Web Services
Amazon EC2 running Microsoft Windows Server is a fast and dependable environment for deploying applications using the Microsoft Web Platform. Amazon EC2 enables you to run compatible Windows-based solutions on AWS' high-performance, reliable, cost-effective, cloud computing platform.
Microsoft Windows Server 2022 Core
By Amazon Web Services
Amazon EC2 running Microsoft Windows Server is a fast and dependable environment for deploying applications using the Microsoft Web Platform. Amazon EC2 enables you to run compatible Windows-based solutions on AWS' high-performance, reliable, cost-effective, cloud computing platform.
Microsoft Windows Server 2019 Core
By Amazon Web Services
Amazon EC2 running Microsoft Windows Server is a fast and dependable environment for deploying applications using the Microsoft Web Platform. Amazon EC2 enables you to run compatible Windows-based solutions on AWS' high-performance, reliable, cost-effective, cloud computing platform.
Microsoft Windows Server 2016 Base
By Amazon Web Services
Amazon EC2 running Microsoft Windows Server is a fast and dependable environment for deploying applications using the Microsoft Web Platform. Amazon EC2 enables you to run compatible Windows-based solutions on AWS' high-performance, reliable, cost-effective, cloud computing platform.
Customer reviews
Vishal B.
Microsoft sql server used for DB management.
Reviewed on May 05, 2022
Review provided by G2
What do you like best about the product?
Microsoft sql server is best for backend database management, we can easily configured this tool with our main code and can use for crud operation and DB changes.
What do you dislike about the product?
Some version of the Microsoft SQL Server does not have or work some of the DB features, like it, lower version of this does not have commit, stored procedure and also does not have a good debugging tool.
What problems is the product solving and how is that benefiting you?
The first and best benefit is, that it is a free tool and also using this we can solve our daily basis problems with DB management, it is used for DB management of any product.
Leave a comment0 comments
David W.
The web version of Microsoft's greatest database server on their most feature-packed and secure OS
Reviewed on Jan 13, 2022
Review provided by G2
What do you like best about the product?
The web version of SQL Server is always good for using on a web server, offering you and your .NET developers a database server they're comfortable with at reduced licensing costs. SQL Server 2016 introduced a lot of great new features, and SQL Server 2019 offers you vast security (such as headless mode, and modern updates) to ensure your web host is protected.
What do you dislike about the product?
Licensing has got more complex, and of course, there's always an additional fee to pay for hosting when using Microsoft vs. open source products - but the trade-off is you will find many more .NET / SQL devs than others.
What problems is the product solving and how is that benefiting you?
We used SQL Server 2016 Web on Windows Server 2019 for our web hosting on an AWS server.
Computer & Network Security
MS SQL Server is just a nuisance that we need to stick to when dealing with legacy environments.
Reviewed on Dec 16, 2021
Review provided by G2
What do you like best about the product?
AWS is a nice environment, and very configurable, but the experience with MS SQL Server is not good enough. The management of resources and scale are simple, practical and intuitive (although it lack some triggers on AWS side to not scale the cost too quickly)
What do you dislike about the product?
Dealing with MS SQL Server is a true nightmare. It's pretty at the beginning, but it doesn't scale with a better performance than free alternatives such as MariaDB, and the integration with NoSQL tools (Neo4J and MongoDB) is too bureaucratic and non intuitive. I'd just recommend SQL Server if there's too much work in transfering the environment to other DBMS.
What problems is the product solving and how is that benefiting you?
I had a system already running on SQL Server that needed to be moved to cloud (due to storage costs not scaling fast enough). The primary usage was to get information for data prediction, which I had to model in NoSQL environments, and migrating it to MariaDB wasn't a viable alternative. The queries to connect SQL Server to our environment, however, were terrible. I found no benefits other than not migrating the entire DB to another DBMS.