Setup SSRS Service Timeout - SQL-FineBuild/Common GitHub Wiki

Previous Setup Service Timeout	Manual Install	Setup Power Configuration Next

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

Many sites have reported a problem with SQL Server 2008 and SQL Server 2008 R2 RS 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 RS re given in the table below:

SQL Version	Windows Version	Set Timeout
SQL 2012 or above	Any	Not needed
SQL 2008 or SQL 2008 R2 with RS	Windows 2012 or above	Not needed
SQL 2008 or SQL 2008 R2 with RS	Windows 2008 R2 or below	Required
SQL 2008 or SQL 2008 R2 without RS	Any	Not needed
SQL 2005 or below	Any	Not needed

FineBuild Setup RS Service Timeout Processing

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

If SQL Server 2008 RS or SQL Server 2008 R2 R2 RS 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 RS Service Timeout Processing

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

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

Open the Registry Editor by Start -> Run and type regedit
Navigate to HKLM\SYSTEM\CurrentControlSet\Control
If it does not already exist, create a DWORD value called ServicesPipeTimeout
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.
If you have changed the service startup timeout value then you must reboot the server before the SQL Server install is started.

Previous Setup Service Timeout	Top	Setup Power Configuration Next