This is probably a super basic question, but if I purchase an OEM SQL Server 2016 Standard edition, how would I install it as 2014 to match the other servers? Can I get a 2014 installer and use the 2016 license key during the installation?
Sql-server – How to install downgrade of SQL Standard 2016 to Standard 2014
installationlicensesql server 2014sql-server-2016
Related Question
- SQL Server – Install Express and Standard Side-by-Side
- Sql-server – SQL Server 2016 Standard Version Features Evaluation
- SQL Server 2016 Standard Edition – Does It Include Replication?
- Sql-server – SQL Server 2014 change license key
- Sql-server – How to uninstall SQL Server 2014 Standard Edition without install media
- SSRS 2017 – Can It Be Used with SQL Server 2016?
- Sql-server – SQL Replication components install in 2016 standard edition
- SQL Server Command Line Install – Change Edition
Best Answer
If you want a Sql Server 2014 instance, you'll need to install that specific version. Installing Sql Server 2016 will create a Sql Server 2016 instance, but you can control certain database behaviors to be compatible with the specified version of SQL Server by ALTERING the COMPATIBILITY_LEVEL.