Coding With Fun
Home Docker Django Node.js Articles Python pip guide FAQ Policy

Can you install sql server 2008 in place of sql 2016?


Asked by Cynthia Morgan on Dec 12, 2021 SQL



But you need to do is install the SQL Server 2016 in-place of SQL Server 2008. With this method, the database and server setting will remain the same. To perform the in-place upgrade of SQL Server 2016, you’ll have to perform the following steps: Insert SQL server installation media and run the Setup.exe file from the root folder.
Keeping this in consideration,
The error is telling you the problem, Windows Server 2008 is not supported by Microsoft SQL Server 2016. As per Hardware and Software Requirements for Installing SQL Server - Processor, Memory, and Operating System Requirements: Principal Editions of SQL Server, SQL Server 2016 can be installed on:
Furthermore, As per Hardware and Software Requirements for Installing SQL Server - Processor, Memory, and Operating System Requirements: Principal Editions of SQL Server, SQL Server 2016 can be installed on: Windows Server 2008 (R2) is not one of those Operating systems. In truth, this is another reason you should be upgrading.
Also Know,
SQL Server 2016 supports upgrade from the following versions of SQL Server: SQL Server 2008 SP4 or later SQL Server 2008 R2 SP3 or later SQL Server 2012 (11.x) SP2 or later SQL Server 2014 (12.x) or later
Moreover,
The only option one should follow if they are using SQL Server 2008/R2, is to upgrade it to the latest version of the SQL Server. SQL Server 2019 allows you to directly upgrade from SQL Server 2008/R2 and keep the database compatibility to the earlier version.