patternsqlMinor
installing SQL SERVER 2016 side-by-side SQL Server 2012
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
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:
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.