1) Query Execution Timeout
You can increase the Query Execution Timeout by opening report into the BI studio
For SQL 2008, follow below step
Go to Report Data Explorer.
You will see the List of the DataSets
Right click on the Appropriate Dataset
Select appropriate the Data Set and click on property. You will find the Timeout Setting. Time out is in the seconds.
In New window Click on the Query tab,You will see the Timeout drop down at bottom
For SQL 2005, follow below step
Goto Data Tab.
Choose Dataset from Dropdown and click on “…” to open the Property
On Query Tab you will find the Timeout Text Box at the bottom left corner.
2)Â Report Execution Timeout
You can set the report to never timeout Â by setting the processing time out setting toÂ Â â€˜Do not timeout report executionâ€™
If timeout is caused by length of the execution of the report then you change the Processing Option.
By default, the value is set to 1800 seconds
Either you can set for specific report or you can Â set value for all reports.
Follow this step to set value for specific report
Go to http://localhost/reports
Select the appropriate report and click on the report and choose “Manage” option.
Click on the tab “Processing Options” and choose the option “Report Timeout”.
Follow this step for global setting
Go to http://localhost/reports
Click on “Site Settings” links at top
3)Â Â HTTP Timeout
You can set the httpruntime to run the large report,
You can alter the value of attributeÂ executionTimeout Â of tagÂ httpRuntime, default value if 9000 and value is in the seconds.
<system.web> <httpRuntime executionTimeout = "9000" /> </system.web>
- Open the Report Serverâ€™s Web.config file generally located at <Drive>:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer
- Locate the HttpRuntime parameter and alter the value. If itÂ doesn’tÂ exist, you will have to create it within the section.
4)Â Â DatabaseQueryTimeout
You can alter the value for DatabaseQueryTimeout in theÂ RSReportServer.config located at
<Drive>:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer
The value of timeout is in seconds and default value is 120.
This value is passed to the System.Data.SQLClient.SQLCommand.CommandTimeout property.
5)Â SessionTimeout andÂ SystemReportTimeout
This the settings controlling the SSRS user session.
The default value of “SessionTimeout”Â is in seconds and default value is 600 and 1800 for “SystemReportTimeout”.
You can edit this value fromÂ ConfigurationInfo Â table of report server.
select * from ConfigurationInfo
where Name in (‘SessionTimeout’,’SystemReportTimeout’)
Â 6)Â Â RecycleTime
This specifies the recycling period for the Reporting Web Service.
this setting has been found inÂ RSReportServer.config,Â If itÂ doesn’tÂ exist, you will have to create it within the section.
The default is 720 and it is in minutes.
You can alter this setting in the web.config located at <Drive>\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager
default value is 20 minutes.
this require iis restart.
this setting is asp.net related.
this setting found in the machine.config file located at <Drive>:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG
<httpRuntime executionTimeout = “1800” maxRequestLength = “4096” >
executiontimeout is in second and default value is 110 seconds.
report might be timeout from asp.net due to the large volume of the data, you can increase the value ofÂ maxRequestLength. size is in the mb.
this doesn’t require system reboot.
I’ve consider the 64 bit version of SQL Server .
Hope this will help you.
Text copied from : http://www.avyuktasolutions.com/blog/sql-server-reporting-services-timeout-settings/