We will be installing SQL Server 2016 Enterprise on Windows 2012-R2

Looking at the "Verify Your Operating System" section of: https://msdn.microsoft.com/en-us/library/ms189910.aspx

It discusses Windows 2008 versions, but not Windows 2012 versions. (I suppose it should also discuss Windows 2016 versions.)

The fundamental questions are:

a) Can I install SQL Server 2016 Enterprise on Win2012-R2 Standard Edition?

b) Can I install SQL Server 2016 Enterprise on Win2016 Standard Edition?

c) In the above setups, can SQL Server access 256GB or more RAM?

d) In the above setups, can I still set up SQL Server Failover Clustering, with one master and two or three read-only failover instances?

  • 1
    That documentation page is incorrect in that it implies you need Windows 2008 or 2008R2 for an FCI on any version. SQL 2014 requires Windows 2008R2+. SQL 2016 requires Windows 2012+. Since Windows 2016 hasn't hit RTM yet, it's also not yet supported, so I wouldn't expect it to be included in the documentation. – AMtwo Sep 20 '16 at 18:54
  • 2
    Windows Server 2012 Standard Edition supports up to 4TB of RAM, so you should be fine from a RAM point of view with 256GB. You can certainly install SQL Server Enterprise on Windows Server Standard. Note @AMtwo's comments on FCI. – Randolph West Sep 20 '16 at 21:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.