Friday, February 4, 2011

How to uninstall SQL Server Reporting Services (SSRS)

Do you know how to remove SSRS, without uninstalling other components of SQL Server?  Easy sneasy, check it out:
  1. Go to your Control Panel Add/Remove, or Programs/Uninstall a program
  2. Double-click 'Microsoft SQL Server 2008 R2'
  3. In the next dialog next, you will see 'Add', 'Repair' and 'Remove'.  You will choose 'Remove', and then 'OK'.
  4. The next dialog is 'Select Instance', you will select the right one, and click 'Next'.
  5. The next dialog is 'Select Features', you will ONLY select 'Reporting Services', and then 'Next'.  This one is important, so I've copied it here:


The uninstall begins now, and when it is done you will see this:
        'Your SQL Server 2008 R2 removal completed successfully'.


You will still need to drop, or remove your ReportServer and ReportServerTempDB databases.


FAQ
Can this be done intra-day, while the server is in use?  Yes.
Does this require a reboot, or service restart?  No.


Please let me know if you have any problems or questions.

No comments:

Post a Comment