Remove SSRS on 2012 enterprise instance.

  • Hi, Have an SQL 2012 server which has all our reporting DBs on it. Anyway business wanted to move from using SAP BO for reporting to an SSRS/SharePoint solution so I installed SSRS into this instance of SQL. Now they've decided to stick with BO so I would like to uninstall SSRS from this instance to remove all the extra overhead etc of the services.

    Is this a simple task I can't find a lot of info about removing it via Google.

  • Usually I do this with the command line. Something like this:

    Setup.exe /Action=Uninstall /FEATURES=RS /INSTANCENAME=MSSQLSERVER

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • You can do it in the GUI by using Control Panel -> Programs and Features. Choose the Microsoft SQL 2012 instance and click "Uninstall". Yes, I know. Panic-inducing moment here, but it will allow you to remove only parts of SQL 2012 without removing the whole thing.

    Um, except... CAVEAT: You can only remove bits on standalone instances of SQL. If this is a clustered instance of SQL, then it's all or nothing. This is what 3 months of installing, uninstalling, re-installing our new environment taught me. It gets messy on the cluster level.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply