Setup SSRS Service Timeout
| 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 |
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.
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.
Copyright FineBuild Team © 2014 - 2018. License and Acknowledgements
| Previous Setup Service Timeout | Top | Setup Power Configuration Next |
|---|