none
How to bypass current SQL Server 2005 instance sp upgrade whern trying to install second instance

    Question

  • I am trying to install a second instance of the reporting services to accommodate external user's, but am having an issue with it. The issue is that the install wants to upgrade the current instance of SQL Server 2005. How can I bypass this and go directly to the installation of the new reporting services instance?
    • Edited by bschave2 Wednesday, April 03, 2013 5:36 PM
    Wednesday, April 03, 2013 5:36 PM

Answers

  • Hello,

    It seems you are trying to install a new instance from SP3 (KB955706) media of SQL Server 2005. Please find the original media of SQL Server 2005, the media you are using is related to a service pack.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by bschave2 Friday, April 05, 2013 10:24 PM
    Thursday, April 04, 2013 2:56 PM

All replies

  • Hello,

    Please run the following command:

    setup.exe /ACTION=Install /FEATURES=RS /INSTANCENAME=REPORTSERVER /RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /RSSVCSTARTUPTYPE=Manual /RSINSTALLMODE=FilesOnlyMode

    You can change the options as needed. For more information, please refer to the following article:

    http://msdn.microsoft.com/en-us/library/ms144259(v=SQL.90).aspx

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, April 03, 2013 7:07 PM
  • there isn't a setup.exe file, just an SQLServer2005SP3-KB955706-x86-ENU.exe file. When I run the executable with an edited version of the command line that you gave me, it went straight to the upgrade once again. Is there something else I can try? BTW, I used the command line:

    SQLServer2005SP3-KB955706-x86-ENU.exe /ACTION=Install /FEATURES=RS /INSTANCENAME=EXTERNALREPORTSERVER /RSSVCACCOUNT="mysvcaccount" /RSSVCSTARTUPTYPE=Manual /RSINSTALLMODE=FilesOnlyMode

    • Edited by bschave2 Thursday, April 04, 2013 2:54 PM
    Thursday, April 04, 2013 2:14 PM
  • Hello,

    It seems you are trying to install a new instance from SP3 (KB955706) media of SQL Server 2005. Please find the original media of SQL Server 2005, the media you are using is related to a service pack.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by bschave2 Friday, April 05, 2013 10:24 PM
    Thursday, April 04, 2013 2:56 PM