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

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Get Your Own Blog

If you would like to blog on SQLServerCentral.com then send an email to webmaster@sqlservercentral.com.

Contact the author

Please log in or register to contact the author of this blog

All Blogs

All Bloggers on SQL Server Central

Feeds

Subscribe to this blog

Archives for this blog

What I Learnt @ Work

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

Posted on 29 April 2011
Comments
Briefcase
Print

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.