Extend Timeout for SQL Reporting Services in SharePoint Integrated Mode

By

Tech Support

Published: November 5, 2009Posted in: Tech TalkTags: Reporting Services, SharePoint, SSRS

WP Greet Box icon

If you find the following article useful, consider subscribing to our RSS feeds for more tasty snacks. If you like it, twit this post or follow us. And if you really like it or you'd like to learn more about SummitCloud solutions, please visit our website.

You may receive an ASP.NET or SharePoint application error when trying to run a report that takes a while in SharePoint Integrated mode. It seems that the standard timeout is well over 2 hours in SQL Native mode, but in SharePoint integrated mode, the default timeout is reduced to 2 minutes.

To extend the SQL Reporting Services timeout, you’ll need to modify the web.config of the SharePoint site that is hosting your reports.

Browse for the node <httpRuntime> within the web.config
Add the property executionTimeout=”9000″ before the end tag
Save and close the file

About the Author

http://www.cheapbootsforsale.us ugg boots

“Well , the view of the passage is totally correct ,your details is really reasonable and you guy give us valuable informative post, I totally agree the standpoint of upstairs. I air jordan 19 often surfing on this forum when I m free and I find there are so much good information we can learn in this forum!
“

SummitCloud Solutions

EDI 852 Reporting

CPSIA, CPSC Compliance and Certificates of Conformity

Reporting Services Optimization and Analysis