Listing Thumbnail

    Microsoft SQL Server 2017 Web 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 2017 Web 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 2017 Web 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_2017: GDR KB5046061
    • 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
    |
    10 external reviews
    External reviews are sourced from G2  and are not included in the star rating for this product.
    Information Technology and Services

    optimized performance with great service by Microsoft Application

    Reviewed on Sep 10, 2024
    Review provided by G2
    What do you like best about the product?
    - The hybrid cloud integration capability let us run the application easily in containers
    - Automaticdatabase tuning feature is really a gamechanger in improvising the query performace .
    What do you dislike about the product?
    the web feature has some limitation when compared to standard edition of the software.
    What problems is the product solving and how is that benefiting you?
    this solutions resolves the issue around the scalability with the stable ecosystem added with analytics capabilty, that makes the availablity of the system reliable .
    Airlines/Aviation

    my view on SQL server

    Reviewed on Sep 04, 2024
    Review provided by G2
    What do you like best about the product?
    From my experience, Microsoft SQL Server 2017 Web on Windows Server 2019 offers a solid balance between performance and cost for web applications. I’ve found it particularly effective for small to medium-sized projects where you need reliable speed and good scalability without overspending.
    What do you dislike about the product?
    While it’s great for basic web applications, you miss out on advanced features like SQL Server Agent for scheduling and certain performance optimizations that are available in the Standard or Enterprise editions. I’ve also found the licensing model a bit restrictive since it's tailored specifically for web hosting, which can limit flexibility if your needs grow beyond that.
    What problems is the product solving and how is that benefiting you?
    The Web edition includes enough features to manage data, maintain reliability, and ensure security without the complexity or cost of higher-tier editions. By running on Windows Server 2019, it also benefits from modern server features, making deployments smoother and easier to manage.
    Information Technology and Services

    easy to use and reliable

    Reviewed on Aug 09, 2024
    Review provided by G2
    What do you like best about the product?
    the reliability of the solution along with security gives developer good confidence to use it along with the maturity and less issues.
    What do you dislike about the product?
    windows pathing along with sql server patching can make it unstable at times and also the licensing cost is also a concern
    What problems is the product solving and how is that benefiting you?
    using it as a database for workloads running in eks cluster by securely connecting to it
    Soumitra S.

    Works fine and meet basic expectations

    Reviewed on May 25, 2024
    Review provided by G2
    What do you like best about the product?
    One of the most important reasons for using this SQL server is that it provides seamless integration with the codebase. Easy to extract databases, supports most of the programming languages and the user interface is also very easy to interact with.
    What do you dislike about the product?
    One of the major drawbacks is that it is not very compatible with Windows 11. Initially, it works fine but eventually SQL server takes a large chunk of memory which as a result makes the overall system slow. As the database size increases it leads to an increase in retrieval time and even hangs sometimes.
    What problems is the product solving and how is that benefiting you?
    Integration with applications is very smooth, programming language support is vast and for an average size of database, data manipulation is extremely easy to do.
    Sidhant S.

    Does the work

    Reviewed on Jan 14, 2024
    Review provided by G2
    What do you like best about the product?
    I think that the best part is that it is compatible with any programming language you use. I have used SQL Server 2017 with Java, .NET and C#. A very good data management tool which helps you to store, retrieve, modify and delete records in the DBMS. The SQL queries used are also very easy to learn. The software is very easy to install and use.
    What do you dislike about the product?
    Storage is the biggest problem. The SQL Server takes up a lot of memory space, by which the system becomes extremely slow. Another concern is about a technical issue we faced, but the free customer support was not adequate, so we had to go for the paid support. Other than that, no other issues so far.
    What problems is the product solving and how is that benefiting you?
    The performance is quite good, connection with other apps and other languages is also very easy. Data modification using APIs is also very convenient. Development is easily done by incorporating SQL Server in our projects.
    View all reviews