RS2k5 Crashes exporting to Excel

We've got a clinet that has no issues exporting reports to excel about 95%
of the time. However, about once a month, they get the error page "For more
information abou this error navigate to the report server on the local
server machine, or enable remote errors."
In the app event logs, there is the following error: Report Server
(MSSQLSERVER) cannot connect to the report server database.
I'm not finding anything useful in the groups. Thanks for any help.Hi Jack,
One good place to look is in the actual SRS error logs. This can usually be
found at <SRS Install Directory>\Reporting Services\LogFiles. Check the
ReportServer logs for the day of the error. Often times, the stack trace of
the error is there and can help you diagnose the root cause of the issue.
Brian
--
Brian Knight
Quaere SQL Server Blog
http://dba.typepad.com
"Jack" wrote:
> We've got a clinet that has no issues exporting reports to excel about 95%
> of the time. However, about once a month, they get the error page "For more
> information abou this error navigate to the report server on the local
> server machine, or enable remote errors."
> In the app event logs, there is the following error: Report Server
> (MSSQLSERVER) cannot connect to the report server database.
> I'm not finding anything useful in the groups. Thanks for any help.
>
>