Sign in
Your Saved List Partners Sell in AWS Marketplace Amazon Web Services Home Help

SQL Server 2016 Express on Windows Server 2012 R2

Cognosys Inc Hardened Images | 22.10.1400

Windows, Windows Server 2016 Base 22.10.1400 - 64-bit Amazon Machine Image (AMI)

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
  • 4 star
  • 3 star
  • 2 star
  • 1 star

External reviews

2 reviews
from G2

External reviews are not included in the AWS star rating for the product.

    David W.

Light version of a robust, reliable database engine on a secure, modern operating system

  • March 16, 2022
  • Review provided by G2

What do you like best?
I've always loved Microsoft SQL Server, and for .NET developers it is an excellent choice of database engine. The Express version is the lightest form but can still be managed through SSMS, however is more license-friendly and this combination - SQL Server 2016 Express on Windows Server 2016 - makes a lot of sense for a data-driven website platform, for example. You can host it outside your organisation and know your .NET apps will run reliably and robustly, your developers and DBAs can work with the data easily, and your licensing costs are reduced. SQL Server 2016 is where Microsoft added a lot of great features like query store and in-memory facilities.
What do you dislike?
On the downside, if you're hosting this product outside your environment and rely on a third-party provider there is, of course, a licensing fee for Windows Server 2016 and SQL Server 2016 Express, compared to open-source options like Linux and MySQL.

Additionally, the way SQL Server Express installs itself can lead to some developers or administrators inadvertently creating database servers like hostname\sqlexpress instead of simply hostname. It's important to be careful when setting it up to ensure you do so in the way you really want.
What problems is the product solving and how is that benefiting you?
We used it for our externally-hosted public-facing website. Our website was an in-house app with many facilities to capture customer requests, provide services, etc., with a lot of API-driven components, content management for our marketing team, and other dynamic features. Being a Microsoft / .NET environment this combination of server and DB was ideal for us and for the team who had a lot of SQL Server experience and affection.

    Computer Software

Great features out of the box

  • March 09, 2022
  • Review provided by G2

What do you like best?
The installation process is very simple. Replication is easy to configure and understand unlike other flavours of SQL. The management tool SSMS is very mature and comes with functionality to help you administrate your clusters.
What do you dislike?
There is nothing to dislike about the product. The one thing to consider though is the pricing, which can be quite expensive for small to medium businesses. It's best to obtain using enterprise agreement with MS.
What problems is the product solving and how is that benefiting you?
On premises to cloud replication has been easier than anticipated using SQL Server 2016. We have found the replication to be very reliable thus far since being setup with not too much maintenance required.

showing 1 - 2