Reporting Services "cannot connect to the report server database"
- by Dano
We have Reporting Services running, and twice in the past 6 months it has been down for 1-3 days, and suddenly it will start working again. The errors range from not being able to view the tree root in a browser, down to being able to insert parameters on a report, but crashing before the report can generate.
Looking at the logs, there is 1 error and 1 warning which seem to correspond somewhat.
ERROR:Event Type: Error
Event Source: Report Server (SQL2K5)
Event Category: Management
Event ID: 107
Date: 2/13/2009
Time: 11:17:19 AM
User: N/A
Computer: ********
Description:
Report Server (SQL2K5) cannot connect to the report server database.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
WARNING: always comes before the previous error
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2/13/2009 11:06:48 AM
Event time (UTC): 2/13/2009 5:06:48 PM
Event ID: 2efdff9e05b14f4fb8dda5ebf16d6772
Event sequence: 550
Event occurrence: 5
Event detail code: 0
Process information:
Process ID: 5368
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: ReportServerException
Exception message: For more information about this error navigate to the report server on the local server machine, or enable remote errors.
During the downtime we tried restarting everything from the server RS runs on, to the database it calls to fill reports with no success. When I came in monday morning it was working again.
Anyone out there have any ideas on what could be causing these issues?
Edit
Tried both suggestions below several months ago to no avail. This issue hasn't arisen since, maybe something out of my control has changed....