reporting services receiving an error

When I try and run a report in mom2005 I get the following message:
Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'ComputerList'. (rsErrorExecutingCommand) Get Online Help
Invalid object name 'SC_Class_Rel_Computer-Exchange_View'.
My software is up to date with all patches and packs.. I am really stuck. could someone please help.. Thanks Lisa
----
--
Message posted via http://www.sqlmonster.comI ran into the same problem.
Here is what I found to fix it:
http://groups-beta.google.com/group/microsoft.public.mom/browse_frm/thread/160cc0d914b28ae4/d4fb34cf84beb0e9?q=SystemCenterReporting+log+file&_done=%2Fgroups%3Fq%3DSystemCenterReporting+log+file%26&_doneTitle=Back+to+Search&&d#d4fb34cf84beb0e9
"Lisa Roy via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:0a8a6903bc44493cbf3e9412dcab6ac6@.SQLMonster.com...
> When I try and run a report in mom2005 I get the following message:
>
> Reporting Services Error
> ----
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'ComputerList'.
> (rsErrorExecutingCommand) Get Online Help
> Invalid object name 'SC_Class_Rel_Computer-Exchange_View'.
> My software is up to date with all patches and packs.. I am really stuck.
> could someone please help.. Thanks Lisa
> ----
> --
> Message posted via http://www.sqlmonster.com

Reporting Services Instance could not be found

Hi

I am receiving an error message when I connect to Reporting Services in SQL Server 2005, the error is:

Cannot connect to <SERVER>

Reporting Services Instance could not be found (Microsoft.Sqlserver.Management.UI.RSClient)

Can anyone help with this please?

Thanks

Can you check if RS is configured properly by going to Start->All programs->Microsoft SQL Server 2005->Configuration Tools->Reporting Services Configuration? Connect to the instance that you are having trouble with.

Also, are you seeing this when navigating to http://<servername>/reports?

Thanks,
Sharmila

|||

Are you running Vista? I had the same problem SP2 for sql2005 fixed it.

Sjoerd

|||

Hi

No the server I was installing on was running W2K, I decided to uninstall SQL Server 2005, delete the virtual directories and Application pool from ISS and delete any remaining data files for SQL Server 2005, then I reinstalled it all again and installed SP1 and everything seems to be working fine now. I think the problem was due to somebody else previously installing it incorrectly...

Thanks for your help!