Steps to Resolve SSRS Timeout Issues
Been awhile since I had posted anything and what better way to restart this blog than with some Timeout Issues. Now this list is designed for SSRS 2005, but you can put a few of these tips to use in 2008. Consider these steps in the below order. 1) Set the HttpRuntime ExecutionTimeout value to a greater value (ie 3 hours) on the Report Server How do you do this? Simple! a. Open the ReportServer’s Web.config file by going to Start -> Administrative Tools -> Internet Information Services. b. From there, expand Web Sites -> Default Web Site, and click on ReportServer. On the right-hand pane, right-click ‘Web.Config’ and select ‘Open’. c. Locate the HttpRuntime parameter. If it doesn’t exist, you will have to create it within the <System.Web> section. d. Set the executionTimeout value to ‘10800’ (3 hours) as shown below: <system.we...