tags:

views:

206

answers:

1
+1  Q: 

How to stop Reporting Services Blocking requests?

We are using Reporting Services 2005 on SQL 2005 and when a report is running then Reporting Services seems to block for that user. e.g. navigating in /Reports/Pages/Folder.aspx will wait until the report finishes before displaying anything. I have had a look at the rsreportserver.config file but nothing in there seems to be limiting things. Also it doesn't seem to be IIS that is blocking.

If the answer to this is Upgrade to 2008 than that is fine.

+2  A: 

It blocks per browser instance. If you start a seperate IE process then you should be able to run multiple reports

Zaid Zawaideh  2009-10-13 14:41:20
Thanks I have verified that, but it's a bit awkward to get users to do that!
Sam Mackrill  2009-10-13 15:19:35
My past investigations indicated that it has to do with the way SSRS deals with session locks (you can check the tempdb session lock table to monitor the locks in realtime). I'd be interested to see if others have work arounds to this.
Zaid Zawaideh  2009-10-13 18:12:11

related questions

Strip HTML from string in SSRS 2005 (VB.NET)
SQL Server 2008 Reporting Services Control
How do I resolve a System.Security.SecurityException with custom code in SSRS?
Sending e-mail from a Custom SQL Server Reporting Services Delivery Extension
How to aggregate data from SQL Server 2005
Is there a Box Plot graph avalible for Reporting Services 2005?
How do I set a textbox to multi-line in SSRS?
SQL 2005 Reporting Services custom report item (CRI) - what are the limits?
SQL Reporting Services viewer for webpage - can you move the View Report button?
Custom font in SQL Server 2005 Reporting Services
I can share a SQL Server Reporting Services Data SOURCE... what about a Data SET?
Enterprise Reporting Solutions
Internationalization in SSRS
Easy way for Crystal Reports to MS SQL Server Reporting Services conversion
SSRS - Post Publishing Tasks
SSRS - Process dies/goes to sleep after not being used
SSRS - RSS Feeds
SSRS - Uninstall Trial Version of VS Business Intelligence
Optimizing the PDF Export of Huge Reports in Sql Reporting Services 2005
SSRS scheduled reports not working.
Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
How do you handle audit logging with SSRS?
Reading recommendations for: SQL Server 2005 Reporting Services
How can I dynamically center an image in a MS Reporting Services report?