Listing Thumbnail

    Microsoft SQL Server 2016 Enterprise on Windows Server 2019

     Info
    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.
    Listing Thumbnail

    Microsoft SQL Server 2016 Enterprise on Windows Server 2019

     Info

    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

    Delivery method

    Delivery option
    64-bit (x86) Amazon Machine Image (AMI)

    Latest version

    Operating system
    Win2019 10

    Features and programs

    Financing for AWS Marketplace purchases

    AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
    Financing for AWS Marketplace purchases

    Pricing

    Microsoft SQL Server 2016 Enterprise on Windows Server 2019

     Info
    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.

    Usage information

     Info

    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..667
    • ENA v2.8.0
    • SSM v3.3.859.0
    • SQL Server CUs installed:
      • SQL_2016_SP3: GDR KB5046063
    • Windows Security Updates current to October 8th 2024

    Additional details

    Usage instructions

    Please visit this following page for more information on using Windows: http://aws.amazon.com/windows/ 

    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

    Customer reviews

    Ratings and reviews

     Info
    0 ratings
    5 star
    4 star
    3 star
    2 star
    1 star
    0%
    0%
    0%
    0%
    0%
    0 AWS reviews
    |
    3 external reviews
    External reviews are sourced from G2  and are not included in the star rating for this product.
    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.
    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.
    View all reviews