Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | shinobigohStarting Member
 
 
                                        13 Posts | 
                                            
                                            |  Posted - 2012-06-27 : 07:26:25 
 |  
                                            | Hi,   I have encountered a weird error  while using sql server reporting services 2008r2.   i tried to schedule 20 reports at the same time. only 1 report is successfully executed. the rest of the reports encountered the this error"the report server cannot open a connection to the report server server database. a connection to the database is required for all requests and processing"but when i scheduled 20 reports at different timing, all the reports can be executed successfullythe rport database that i want to connect is on sql server 2008r2 failover clusteringcan anyone advise me on how to troubleshoot this issue.thank you |  |  
                                |  |  |  |