We just started to use Reporting Services in integrated mode (SQL Server 2005, MOSS 2007). The huge problem is we unable to build models of big databases:
"Server was unable to process request. ---> The operation has timed out "
The process teminates correctly if database is small enouth to finish model building under appoximatly 100 sec. CurentlyÃÂ I increased timeout values in site and RS service config files:
ÃÂ rsreportserver.config:ÃÂ <Add Key="SQLCommandTimeoutSeconds" Value="2400"/>ÃÂ <Add Key="DatabaseQueryTimeout" Value="9000"/>
ÃÂ site web.configÃÂ ÃÂ ÃÂ :ÃÂ <httpRuntime maxRequestLength="51200" executionTimeout="9000" />
Still having same problem. Any suggestions where I can find that 100 sec value? Please help.
View Complete Post