2018年4月24日 星期二

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

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
Reporting Services service doesn’t start after the installation of MS12-070 security patch


沒有留言:

SQL Server Planning, Pricing and License

  Server-CALs授權模式 1.需購買的量應該是所有終端用戶的電腦 例如:一台Data warehouse主機 與 一台Web報表主機,但公司有50人或電腦會連進Web報表主機開啟報表,則應該每一台用戶端電腦都需要有CALs授權,Data warehouse主機購買Ser...