2.01.2009

How To Uninstall SQL Server 2008 Reporting Services

I was setting up a CRM development server with SQL 2008 and made the quick, uninformed, and ultimately time-consuming decision to install Reporting Services in SharePoint integrated mode. I was also going to install WSS 3.0, so I thought I'd try this out.

Unfortunately, I found out later that CRM 4.0 does not support reporting services in SharePoint integrated mode. So, if I had been thinking clearly, this would have been a not too difficult problem: just uninstall reporting services and reinstall it in the right mode.

My problem: I couldn't figure out for the life of me how to uninstall Reporting Services for SQL 2008. I tried everything I could think of to remove it. It wasn't listed separately under the Programs and Features list, and I couldn't find any other way despite hours (ugh!) of searching.

I finally figured out that if I went to the Add/Remove Programs area (Programs and Features in Server 2008), and started an uninstall of SQL Server 2008, I would get the option to select which feature of SQL I wanted to remove. Duh. I feel like an idiot.

15 comments:

Michelle said...

Matt I found your blog post about the fact that CRM 4.0 does not support reporting services in SharePoint integrated mode, and I would like to know if maybe this is why I get the following error when I try to run the reports in CRM 4.0. Reporting Error " The report cannot be displayed". We are running Windows 2008 and CRM 4.0 . Thanks Michelle

Matt Wittemann said...

That error message is pretty generic and can be the result of a number of things. But if you have SQL 2008 running in SharePoint integrated mode, you definitely won't be able to get reports working in CRM. On the other hand, to troubleshoot this further, try browsing to your reporting services website (usually something like http://ssrs-server/reports, where ssrs-server is the server name where your SSRS is installed). If you can get to that website and see the CRM reports there you might get a more detailed error message when you try to run them.

Michelle said...

I've tried to browse to my reporting services website. I can get there but I can't see the CRM reports. What do I need to do so I can see them ?
Thanks

Matt Wittemann said...

Try logging onto the server where your SSRS website is. If you're already logged on and can't see any of the settings links for SSRS, close IE and open it again by right-clicking and choosing "Run As Administrator." Then browse to the SSRS website again. You may need to add your user account as a Content Manager in the SSRS security settings in order to verify that the CRM reports have been published and can be run from there.

bh said...

I get below error message when try to reinstall reporting services 2008 at window server 2003 enterprise edition SP2.

=== Verbose logging started: 7/14/2009 9:10:03 Build type: SHIP UNICODE 4.05.6001.00 Calling process: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x64\setup100.exe === MSI (c) (04:78) [09:10:03:718]: Resetting cached policy values MSI (c) (04:78) [09:10:03:718]: Machine policy value 'Debug' is 0 MSI (c) (04:78) [09:10:03:718]: ******* RunEngine:
******* Product: M:\x64\setup\sql_rs.msi
******* Action:
******* CommandLine: ********** MSI (c) (04:78) [09:10:03:718]: Client-side and UI is none or basic:
Running entire install on the server.
MSI (c) (04:78) [09:10:03:718]: Grabbed execution mutex.
MSI (c) (04:78) [09:10:03:718]: Cloaking enabled.
MSI (c) (04:78) [09:10:03:718]: Attempting to enable all disabled privileges before calling Install on Server MSI (c) (04:78) [09:10:03:718]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (FC:C0) [09:10:03:718]: Running installation inside multi-package transaction M:\x64\setup\sql_rs.msi MSI (s) (FC:C0) [09:10:03:718]: Grabbed execution mutex.
MSI (s) (FC:38) [09:10:03:718]: Resetting cached policy values MSI (s) (FC:38) [09:10:03:718]: Machine policy value 'Debug' is 0 MSI (s) (FC:38) [09:10:03:718]: ******* RunEngine:
******* Product: M:\x64\setup\sql_rs.msi
******* Action:
******* CommandLine: ********** MSI (s) (FC:38) [09:10:03:718]: Machine policy value 'TransformsSecure'
is 1
MSI (s) (FC:38) [09:10:03:718]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (FC:38) [09:10:03:718]: Specified instance {2453DBC8-ACC4-4711-BD03-0C15353AA3D8} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
MSI (s) (FC:38) [09:10:03:718]: MainEngineThread is returning 1639 MSI (s) (FC:C0) [09:10:03:718]: User policy value 'DisableRollback' is 0 MSI (s) (FC:C0) [09:10:03:718]: Machine policy value 'DisableRollback'
is 0
MSI (s) (FC:C0) [09:10:03:718]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (FC:C0) [09:10:03:718]: Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\R
ollback\Scripts 3: 2
MSI (s) (FC:C0) [09:10:03:718]: Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\R
ollback\Scripts 3: 2
MSI (s) (FC:C0) [09:10:03:718]: Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\I
nProgress 3: 2
MSI (s) (FC:C0) [09:10:03:718]: Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\I
nProgress 3: 2
MSI (s) (FC:C0) [09:10:03:718]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after
decrement: -1
MSI (s) (FC:C0) [09:10:03:718]: Restoring environment variables MSI (c) (04:78) [09:10:03:718]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after
decrement: -1
MSI (c) (04:78) [09:10:03:718]: MainEngineThread is returning 1639 === Verbose logging stopped: 7/14/2009 9:10:03 ===


Can anyone tell me how can i solve it?Thanks.

regards,
Sim

Tony J said...

Hi Matt, I ran into you blog via a google search on uninstalling Reports Services. I need to reinstall it from fresh - You said you just went into Add/Remove Programs? Can you give me a little more details? I have some important DBs running on this server, and it's only the RS that's a pain in the ***! I'd rather not have to restore from mirror if I mess it up :P

Thanks!

Matt Wittemann said...

When you start to uninstall SQL Server, you will be presented with options allowing you to choose which features of SQL Server you wish to remove. Before doing this, make backups of all your databases. After you uninstall SSRS and reinstall it, you should be able to restore your reports database from the backup (assuming the database wasn't the problem that led you to uninstall SSRS in the first place). Good luck!

Anonymous said...

thanks a ton man!! i was also struggling to uninstall rs from 2008..ur post made my life easier..

Matt Wittemann said...

Glad this helped. This is one of those things that, after you see how to do it, it seems obvious. But it would be great if it were more intuitive (hint to Microsoft SQL Server dev team...)

Jeff said...

Thanks Matt. I was just sitting here staring at the Add/Remove/Repair screen wondering what to click.

I didn't want to click "Remove" and have everything just start uninstalling.

darin said...

This helped me as well. You don't think to select Remove unless you want to remove ALL of SQL Server. Plus most MS programs like Office, etc, do not do it this way. I suspect the reason they do it this way, is that they don't want to give you the ability to ADD and REMOVE in the same uninstall sequence.

seth j hersh said...

This was very helpful and a thoroughly "clean" way to get my SSRS2008 installation cleaned up (I had lingering conflicts with a leftover SSRS2005 installation.) after upgrading to SQL2008.

Takes a very short amount of time, is direct and right-on-target,so-direct kind of solution.

seth j hersh
ny

Mark Chaffee said...

Matt,

I had the same issue. Actually it is nice to know that even an MVP has the same silly issues as us average guys.

darksander said...

Replace CRM 4.0 with CRM 2011 and you get my issue.

Thanks for the tip!

Anonymous said...

i just went to control panel --> Administrative Tools --> Services and Stoped the SQL Server 2008 Reporting service from running and it worked.

 
ICU MSCRM © 2004-2009