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.

 All Forums
 Development Tools
 Reporting Services Development
 encountered a weird error while scheduled. report

Author  Topic 

shinobigoh
Starting 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 successfully

the rport database that i want to connect is on sql server 2008r2 failover clustering

can anyone advise me on how to troubleshoot this issue.

thank you
   

- Advertisement -