There
are a lot of instances where the Reporting setup does not behave as expected.
Data Warehouse errors, Reporting hierarchy failed errors, and many other such
errors are an indication that something is wrong. Sometimes it might be a
simple fix, but at times we need to completely re do the reporting setup.
These are the high level steps to uninstall the Reporting DB,
Here you will find the resetsrs.exe utility for your hardware version (x86 or x64)
These are the high level steps to uninstall the Reporting DB,
Go to control Panel ->
Add remove programs -> Uninstall the SCOM 2007 reporting server
Once this is done, use
your SCOM 2007 R2 media. Go to the \support tools\Here you will find the resetsrs.exe utility for your hardware version (x86 or x64)