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

Archives: April 2011

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… Read more

1 comments, 4,689 reads

Posted in What I Learnt @ Work on 29 April 2011

SSRS 2005 Error: The Declare cursor SQL construct or statement is not supported

Few days back I downloaded a SSRS 2005 file from one of our internal report server and started modifying it. It had lot of datasets and the datasets contains huge T-SQL commands. When I tried to modify one dataset I got an error

Bit surprised because the report was working… Read more

0 comments, 573 reads

Posted in What I Learnt @ Work on 12 April 2011