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.

17 comments:

  1. Very very good! Thanks

    ReplyDelete
  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

    ReplyDelete
  3. A really detailed and understandable guide, I am sure that even beginners will be able to install it without any problems.

    ReplyDelete
  4. I'm constantly searching on the internet for posts that will help me. Too much is clearly to learn about this. I believe you created good quality items in Functions also. Keep working, congrats! https://serverbrowse.com/

    ReplyDelete
  5. I found your this post while searching for some related information on blog search...Its a good post..keep posting and update the information. business setup dubai

    ReplyDelete
  6. This type of message always inspiring and I prefer to read quality content, so happy to find good place to many here in the post, the writing is just great, thanks for the post. corner pedestal sink

    ReplyDelete
  7. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here keep up the good work Plombier Paris

    ReplyDelete
  8. Please let me know if you’re looking for a article writer for your site. You have some really great posts and I feel I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some material for your blog in exchange for a link back to mine. Please send me an email if interested. Thank you! Alkosto: Hiperahorro para todos

    ReplyDelete
  9. this is really nice to read..informative post is very good to read..thanks a lot! SD-WAN

    ReplyDelete
  10. Thank you, Jack! Please let me know if there are any other topics or needs you'd like to read more on.

    ReplyDelete
  11. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. dr-wall

    ReplyDelete
    Replies
    1. My pleasure! And thank you for the input. I've been remiss lately, but I will get some new stuff out here very soon. Please don't hesitate to let me know if there is anything specific you are looking for, or I may help with.

      Delete
  12. This comment has been removed by a blog administrator.

    ReplyDelete
  13. Thank you so much! This is exactly what I needed to accomplish. Steps were clearly written!

    ReplyDelete
    Replies
    1. Very good! I am glad to hear it. Thank you for the compliment!!

      Delete