title: Reporting Services "cannot connect to the report server database"
body: <p>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.</p>
  
  <p>Looking at the logs, there is 1 error and 1 warning which seem to correspond somewhat.</p>
  
  <pre><code>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.
  </code></pre>
  
  <p>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. </p>
  
  <p>Anyone out there have any ideas on what could be causing these issues?</p>
  
  <p><strong>EDIT</strong></p>
  
  <hr>
  
  <p>Tried both suggestions below several months ago to no avail. This issue hasn't arisen since, maybe something out of my control has changed....</p>