Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SSRS Error: A connection to the database is required for all requests and processing

This error

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

occurs when the SQL SERVER instance, to which SSRS is pointed to, is down or a very silly mistake, the SSRS is not at all mapped to a SQL SERVER database as happened in my case.

You can map the SSRS to a SQL SERVER database by using the Reporting Services Configuration Manager.


Comments

Posted by andriy k on 9 December 2012

thanks a lot for your post man!

i've had the very similar issue and your message helped me to solve it.

Leave a Comment

Please register or log in to leave a comment.