Listing Thumbnail

    Microsoft SQL Server 2016 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 2016 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 2016 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_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
    |
    12 external reviews
    External reviews are sourced from G2  and are not included in the star rating for this product.
    Sadikshya S.

    My experience with SQL Server

    Reviewed on Jan 16, 2024
    Review provided by G2
    What do you like best about the product?
    What i like most about microsoft sql server is cost effectiveness supporting the web based applications and hosting scenarious.SQL Server 2016 Web Edition supports scalability, allowing businesses to scale their web applications as needed. This is crucial for accommodating growth and increasing demand without facing significant limitations.SQL Server 2016, including the Web Edition, incorporates robust security features to protect data integrity and confidentiality. This includes encryption, access controls, and auditing capabilities.
    What do you dislike about the product?
    Depending on the scale and complexity of your web applications, SQL Server 2016 Web Edition may be resource-intensive. Businesses with high transaction volumes or complex queries may need to carefully manage server resources to ensure optimal performance.The Web Edition lacks certain enterprise-level features that are available in editions like SQL Server Standard or Enterprise. Organizations with advanced requirements may find themselves needing features that are not present in the Web Edition.
    What problems is the product solving and how is that benefiting you?
    SQL Server 2016 Web Edition supports scalability, allowing organizations to scale their web applications as needed. This is particularly beneficial for businesses experiencing growth in web traffic or data volume.SQL Server 2016, including the Web Edition, incorporates robust security features. This helps organizations protect sensitive data and maintain the integrity and confidentiality of their databases, which is crucial for web applications dealing with user information. SQL Server Management Studio (SSMS) provides a user-friendly interface for managing and administering SQL Server databases. This ease of management is beneficial for organizations with web developers and administrators who need efficient tools for database tasks.
    Rajendra V.

    Scalability, security & standard commits

    Reviewed on Apr 04, 2022
    Review provided by G2
    What do you like best about the product?
    Many more features like DB backup, monitoring and SQL server job creation features are also used and liked
    What do you dislike about the product?
    I feel that they should bring a document type of database concept
    What problems is the product solving and how is that benefiting you?
    maximum benefits to GUI application while support to provide data visibility from the back end.
    Consumer Electronics

    Very comprehensive and powerful RDBMS

    Reviewed on Mar 24, 2022
    Review provided by G2
    What do you like best about the product?
    Cross platform usability along with very complete business intelligence capabilities. Ability to integrate with various applications is another added features.
    What do you dislike about the product?
    Just need to be more developer friendly with detailed and comprehensive error message. Also need to have additional new and modern functions.
    What problems is the product solving and how is that benefiting you?
    Storing high frequency data and a data warehouse for analytical purposes
    Harini V.

    Microsoft SQL Server

    Reviewed on Mar 05, 2022
    Review provided by G2
    What do you like best about the product?
    The questions which had asked in the assessment made me to learn few new things and that helped me to enhance the skill , competitors feel this is hard assessment to finish
    What do you dislike about the product?
    I have nothing like dislike there is nothing that is missing or nothing like not working properly , there is nothing to be improved you people are the best and improved me
    What problems is the product solving and how is that benefiting you?
    You're dealing with an application whose newest supported version is only SQL Server 2014 , but not 2016. Or newer . you want to use Always On Availibility Groups
    Recommendations to others considering the product:
    Yes I will recommend considering Microsoft SQL
    Venkat Manoj M.

    Windows Server 2016 recommendation

    Reviewed on Feb 28, 2022
    Review provided by G2
    What do you like best about the product?
    In memory improvements
    Row level support
    What do you dislike about the product?
    Database may face out of space error
    Client loses connection to the sql server
    What problems is the product solving and how is that benefiting you?
    Provides optimized performance
    Better security and offers large sized database
    View all reviews