This project has moved. For the latest updates, please go here.

Previous Setup Service Timeout Manual Install Setup Power Configuration Next

Setup SSRS Service Timeout

FineBuild can set the Windows Service Timeout value to allow SQL Server 2008 R2 SSRS to start correctly.

Many sites have reported a problem with SQL Server 2008 and SQL Server 2008 R2 SSRS not starting correctly if SP2 or above is installed. This problem does not occurr with other versions of SQL Server, and only happens on Windows 2008 R2 and below. Microsoft has published a work-round that fixes this problem for some situations, but the only fix known to work in all situations is to increase the Windows Service Timeout limit.

The requirements to change the Windows Service Timeout limit for SSRS re given in the table below:
SQL Version Windows Version Set Timeout
SQL 2005 or below Any Not needed
SQL 2008 +/- R2 without SSRS Any Not needed
SQL 2008 +/- R2 with SSRS and SP2 Windows 2008 R2 or below Required
SQL 2008 +/- R2 with SSRS and SP2 Windows 2012 or above Not needed
SQL 2012 or above Any Not needed

FineBuild Setup SSRS Service Timeout Processing

Automated processing of Setup SSRS Service Timeout relates to Process Id 1CB in the FineBuild1Preparation script.

If SQL Server 2008 R2 SSRS is being installed at SP2 or above, and also being installed on Windows 2008 R2 or below, then FineBuild will set the Windows service timeout value to 1 minute if it is currently set to a lower value. This process is not required for other versions of SQL Server.

If FineBuild does change the service timeout value then it will also schedule a reboot of the server that will be performed before the SQL Server install is started.
Top

Manual Setup SSRS Service Timeout Processing

The following steps show what you would have to do to setup SSRS Service Timeout manually. FineBuild does all of this work for you automatically.

If SQL Server 2008 R2 SSRS is being installed at SP2 or above, and also being installed on Windows 2008 R2 or below, the Windows Service Timeout must be set to at least 1 minute to allow the SSRS service time to start.

1) Open the Registry Editor by Start -> Run and type regedit
RegeditCmd.png
2) Navigate to HKLM\SYSTEM\CurrentControlSet\Control
HKLMControl.png
3) If it does not already exist, create a DWORD value called ServicesPipeTimeout
DWORD.png
4) Set the value of ServicesPipeTimeout to 60000 if it is currently less than that value.

Ensure that Base is set to Decimal. The value is measured in milliseconds, so a value of 60000 relates to 1 minute. Do not reduce the value to 60000 if it is currently set to a higher value or you may prevent some Windows services from starting.
TimeoutValue.png
5) If you have changed the service startup timeout value then you must reboot the server before the SQL Server install is started.

Copyright FineBuild Team © 2014 - 2016. License and Acknowledgements
Previous Setup Service Timeout Top Setup Power Configuration Next

Last edited Aug 27, 2016 at 1:03 PM by EdVassie, version 3