HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

installing SQL SERVER 2016 side-by-side SQL Server 2012

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
2012sqlsideinstallingserver2016

Problem

I am trying to install SQL Server 2016 on a server that already has SQL Server 2012 instances installed - all of the shared and instance features of the 2012 version have been installed also. I do not have an option of uninstalling these and I just need to install a separate, independent SQL SERVER 2016 instance.

According to MS, side-by-side is supported. But then it says: "you cannot prepare a SQL Server 2016 instance side by side with a prepared instance of SQL Server 2012"

What does this mean? So can I have them side-by-side without any issues or not?

Thank you very much

Solution

Installing SQL Server 2016 side by side with an existing SQL Server 2012 can (usually) be installed without issues and is supported as they state in that article.


SQL Server supports multiple instances of the Database Engine,
Analysis Services, and Reporting Services on the same computer.

What you can't do however is using SQL Server Sysprep to install different versions side by side.

SQL Server Sysprep is basically an image based deployment solution like you have Sysprep for windows images.

So as long as you manually run through the installation wizard you are fine, but you wouldn't be able to install a SQL Server image using a prepared image by selecting this option on the advanced tab:

Context

StackExchange Database Administrators Q#151708, answer score: 7

Revisions (0)

No revisions yet.