none
Cannot install SQL 2005 on a machine with SQL 2012 instance(s)

    Question

  • I am attempting to install a named instance of SQL 2005 dev edition.

    The target machine already has several named instances of SQL 2012.

    Setup of SQL 2005 failed with the error "An installation package for the product Microsoft SQL Server Native Client cannot be found".

    This error apparently occurs because a newer version exists from the 2012 install. However, uninstalling native client and attempting to install SQL 2005 again then fails with a similar error, but this time for the VSS writer.

    This page http://msdn.microsoft.com/en-us/library/ms143694.aspx indicates that it should be possible to install SQL 2005 on a machine that already has SQL 2012 installed, but what I am seeing is that I will need to uninstall rather a lot of components of the 2012 install (probably breaking those instances) before installing SQL 2005. 

    Is there a workaround for this that does not involve breaking all existing 2012 instances?


    Thursday, January 23, 2014 12:50 AM

Answers

  • It is not the case that we should expect these issues when installing older versions next to newer versions, since the installation of SQL2005 on a server that already has SQL2012 installed is, as specified in my link in the OP, explicitly listed as supported.

    I solved the problem by extracting the contents of the SQL 2012 installation media to the local machine (without performing an install), then re-executing SQL 2005 setup.

    • Marked as answer by allmhuran Wednesday, January 29, 2014 3:56 AM
    Wednesday, January 29, 2014 3:56 AM

All replies

  • Hello,

    Does that computer have Windows 8 (or later) or Windows Server 2012 (or later)? You cannot install SQL Server 2005 on those operating systems. It is not supported.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


    Thursday, January 23, 2014 2:05 AM
    Moderator
  • The server is windows 2008R2 SP1
    Thursday, January 23, 2014 2:56 AM
  • Hello,

    Could you try to copy the media to a folder on the local drive and install from there? If the SQL Server 2005 media has two CDs, install from CD1 first.

    Could you please share the Summary.txt log file? The following article may help you locate the file on disk:

    http://technet.microsoft.com/en-us/library/ms143702(v=sql.90).aspx

    SP3 for SQL Server 2005 is required on Windows Server 2008 R2.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, January 23, 2014 4:03 AM
    Moderator
  • It's probably the SP3 requirement.. I'll put together a slipstream and give it another go tomorrow.
    Thursday, January 23, 2014 6:54 AM
  • Hello,

    To my knowledge you cannot slipstream a SQL Server 2005 media with a service pack. That’s a feature available on SQL Server 2008 and later.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, January 23, 2014 12:52 PM
    Moderator
  • Yes, I forgot about that.

    OK, so the original problem still stands. SQL 2005 is complaining that it cannot be installed on a windows 2008R2 server if I already have SQL 2012 instances installed.

    Interestingly, SQL 2005 setup is complaining about being unable to find the 2012 VSS writer. From the summary log:

    "

    Product         : SQL VSS Writer
    Error           : An installation package for the product Microsoft VSS Writer for SQL Server 2012 cannot be found. Try the installation again using a valid copy of the installation package 'SqlWriter.msi'.

    "



    • Edited by allmhuran Monday, January 27, 2014 11:45 PM
    Monday, January 27, 2014 10:53 PM
  • Hello,

    Try to uninstall only SQL Server 2012 native client using Control Panel and then try to install SQL Server 2005 again.

    Always expect this kind of issues when you install newer version of SQL Server first and then you want to install older versions. If you do it otherwise, success is almost guaranteed.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, January 28, 2014 4:09 AM
    Moderator
  • It is not the case that we should expect these issues when installing older versions next to newer versions, since the installation of SQL2005 on a server that already has SQL2012 installed is, as specified in my link in the OP, explicitly listed as supported.

    I solved the problem by extracting the contents of the SQL 2012 installation media to the local machine (without performing an install), then re-executing SQL 2005 setup.

    • Marked as answer by allmhuran Wednesday, January 29, 2014 3:56 AM
    Wednesday, January 29, 2014 3:56 AM