sql server reporting services: We are experiencing the error below on our SQL Server 2005 server. Any help
would be appreciated. Thank you.

Report Server Windows Service (MSSQLSERVER) cannot connect to the report
server database.
--

Mike,

Try using the Reporting Services Configuration tool to help troubleshoot.

Steve MunLeeuw

[quoted text, click to view]

I assume this is your Report Server database you are referring to?

Does this correct itself or do you have to restart the sql server or
service?

I'm getting these errors a lot in our production environment. They seem
to occur when there are large, poorly performing reports running. Check
to see what's running at the time of the error to see if you have long
running queries running.

I also get this one a lot too--> Scheduled operations cannot be
created. SQL Server Agent is not running.

Reporting Services does not seem to be able to handle much of a
workload.

[quoted text, click to view]