Friday, March 9, 2012

Report Server Windows Service cannot connect to the report server

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.
--
MikeMike,
Try using the Reporting Services Configuration tool to help troubleshoot.
Steve MunLeeuw
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:D25C9CD8-7279-428C-AEE6-C535157ED8D6@.microsoft.com...
> 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|||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.
Mike wrote:
> 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

No comments:

Post a Comment