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.

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.


  1. Very very good! Thanks

  2. Wow, excellent post. I'd like to draft like this too - taking time and real hard work to make a great article. This post has encouraged me to write some posts that I am going to write soon. transcription services usa

  3. Great Article. Thank you for sharing! Really an awesome post for every one.

    IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

    JavaScript Training in Chennai

    JavaScript Training in Chennai