Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is a 2005 and 2014 side-by-side install a supported scenario? Expand / Collapse
Author
Message
Posted Thursday, May 1, 2014 8:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 25, 2014 4:31 PM
Points: 215, Visits: 843
http://msdn.microsoft.com/en-us/library/ms143393(v=sql.120).aspx (Supported Version and Edition Upgrades) seems to indicate that upgrade installs are okay but side-by-side installs are not:

SQL Server 2014 supports upgrade from the following versions of SQL Server:
SQL Server 2005 SP4 or later

The table below lists the supported upgrade scenarios from earlier versions of SQL Server to SQL Server 2014.

UPGRADE FROM SUPPORTED UPGRADE PATH
SQL Server 2005 SP4 Standard SQL Server 2014 Standard

Any scenarios not specified in the list above are not supported, including but not limited to the following:
Installing SQL Server 2005 and SQL Server 2014 on same computer (side by side).


http://msdn.microsoft.com/en-us/library/ms143694(v=sql.120).aspx (Work with Multiple Versions and Instances of SQL Server) however clearly indicates that side-by-side installs are fine:

You can install SQL Server on a computer that is already running instances of an earlier SQL Server version. If a default instance already exists on the computer, SQL Server must be installed as a named instance.

The following table shows side-by-side support for SQL Server 2014:

EXISTING INSTANCE OF SQL SERVER 2014 SIDE-BY-SIDE SUPPORT
SQL Server 2014 (32-bit) SQL Server 2005 (32-bit)
SQL Server 2005 (64-bit) x64
SQL Server 2014 (64-bit) x64 SQL Server 2005 (32-bit)
SQL Server 2005 (64-bit) x64


I'm also not sure if there's any significance to that text; where it refers to installing newer versions after older versions, in contrast to the heading titles that refer to "existing instance of 2014" which implies installing an older version after a newer one...

Poor documentation, or my mistake?
Post #1566725
Posted Thursday, May 1, 2014 9:03 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 3:34 PM
Points: 15,661, Visits: 28,051
I have not tested it, but there's no reason why it won't work just fine. Each instance of SQL Server and each version gets it's own installation.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1566743
Posted Friday, May 2, 2014 11:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 11:19 AM
Points: 105, Visits: 191
Here is a doc with the limitations and supported side-by-side versions:

http://technet.microsoft.com/en-us/library/ms143694.aspx


-- Wally
-- Reluctant DBA
Post #1567129
Posted Friday, May 2, 2014 11:29 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 7:27 PM
Points: 33,204, Visits: 15,351
the one thing I'd be wary of is shared stuff. If you run any of the non-instanc-aware features, be careful of the 2014 install. However like Grant, i'd think this would work.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1567134
Posted Friday, May 2, 2014 12:19 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:26 AM
Points: 1,750, Visits: 4,588
For what it's worth, have a test system with 2005 and 2014 on it, not on the same drives though, 2005 is a default 1433 instance, 2014 a named instance, so far so good.
Post #1567145
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse