locked
SSRS installation on existing default instance: SQL Server 2008R2 RRS feed

  • Question

  • 

    Hi,

    I'm trying my best to install SSRS on the default instance but its just not working out for me.

    I wanted to add this ssrs on a already existing instance instead of creating a new.

    Steps followed > control panel > SQL Server 2008 R2 > ADD > picked up the SQL server .exe > followed the steps to add SSRS on existing instance.

    Error message: SQL Server 2008R2 specified instance name is already in use by an existing sql server instance.... screenshot below...

    When I try to remove SSRS using control panel > remove / Repair feature > I don't get SSRS over there... so not sure what's happening.

    Saturday, October 15, 2016 7:38 PM

Answers

  • Hello,

    Only the shared components belong to SQL Server 2008 R2. The default instance is SQL Server 2012.

    If you want to install SSRS on SQL Server 2008 R2 then create a new named instance or locate the SQL Server 2012 media and install SSRS on the default instance.

    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

     

    • Proposed as answer by Dan English Sunday, October 16, 2016 2:24 AM
    • Marked as answer by StSingh Tuesday, October 18, 2016 6:34 PM
    Sunday, October 16, 2016 1:20 AM

All replies

  • Hi Stsingh,

    <gs class="GINGER_SOFTWARE_mark" ginger_software_uiphraseguid="d0c008b1-94b7-468e-84ad-b6577d918e33" id="89592f42-70d2-4d98-a2e7-8466402a9647">try</gs> this.

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

    How trying <gs class="GINGER_SOFTWARE_mark" ginger_software_uiphraseguid="5591889a-a916-4939-a5bc-e07d129aa9dd" id="36a6ba17-5991-4024-a246-2e643b91d4c1">adding</gs> <gs class="GINGER_SOFTWARE_mark" ginger_software_uiphraseguid="5591889a-a916-4939-a5bc-e07d129aa9dd" id="157e3009-9903-469f-989a-ed9f308d2257">freature</gs> or installation new instance<gs class="GINGER_SOFTWARE_mark" ginger_software_uiphraseguid="5591889a-a916-4939-a5bc-e07d129aa9dd" id="9b666997-37d0-410f-8ccc-43ea475e0d7e">?</gs>


    Please click Mark As Answer if my post helped.

    Sunday, October 16, 2016 1:16 AM
  • Hello,

    Only the shared components belong to SQL Server 2008 R2. The default instance is SQL Server 2012.

    If you want to install SSRS on SQL Server 2008 R2 then create a new named instance or locate the SQL Server 2012 media and install SSRS on the default instance.

    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

     

    • Proposed as answer by Dan English Sunday, October 16, 2016 2:24 AM
    • Marked as answer by StSingh Tuesday, October 18, 2016 6:34 PM
    Sunday, October 16, 2016 1:20 AM