SQL Server Reporting Services failed to start (Reporting Services啟動失敗)

  • Article

SQL Server Reporting Services failed to start

Reporting Services啟動失敗

Problem 問題:

The SQL Server Reporting Services (MSSQLSERVER) service failed to start due to the following error:

The service did not respond to the start or control request in a timely fashion.

 

Resolution 解決方法:

有三種解決方法，以下是我常用的一種

To increase the default service time-out, follow these steps:

    1. Click Start, click Run, type regedit in the Open box, and then click OK.
    2. Locate and then select the following registry subkey:  
    3. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
    4. Right-click Control, point to New, and then click DWORD.
    5. In the New Value box, type ServicesPipeTimeout, and then press Enter.
    6. Right-click ServicesPipeTimeout, and then click Modify.
    7. Click Decimal, type the number of milliseconds that you want to wait until the service times out, and then click OK.
    8. For example, to wait 60 seconds before the service times out, type 60000.
    9. On the File menu, click Exit, and then restart the computer.

 

其他解決方法請參考以下連結文件

You cannot start SQL Server Reporting Services after you apply the update that is discussed in KB 2677070 https://support.microsoft.com/en-us/help/2745448/you-cannot-start-sql-server-reporting-services-after-you-apply-the-upd

Reporting Services service doesn’t start after the installation of MS12-070 security patch https://blogs.msdn.microsoft.com/mariae/2012/11/12/reporting-services-service-doesnt-start-after-the-installation-of-ms12-070-security-patch/