Guideline for SQL Server configuration, installation and database creation

Guideline for SQL Server configuration, installation and database creation

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. 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/

Cluster service verification failed 叢集服務驗證失敗

Cluster service verification failed
叢集服務驗證失敗

Cause:

如果在Windows 2012 R2 failover cluster上安裝SQL Server 2008 R2 cluster將會遇到此錯誤

Rule "Cluster service verification" failed.

Resolution: 解決方法

事先啟用 Failover Cluster Automation Server功能

Using SQL Server in Windows 8 and later versions of Windows operating system

https://support.microsoft.com/en-us/kb/2681562

To resolve this issue, do one of the following:

• Enable the Failover Cluster Automation Server feature on each node by using Server Manager. In Server Manager, expand Remote Server Administration Tools, expand Feature Administration Tools, expand Failover Clustering Tools, and then click to select Failover Cluster Automation Server. (The screen shot for this step follows.)