Today, one of my clients reported that, the reporting service cannot started.
They didn’t change anything and database service is running fine.

Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date: 12/10/2009
Time: 11:53:21 PM
User: N/A
Computer: ABC
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 7/27/2008
Time: 7:26:24 PM
User: N/A
Computer: PRODB
Description:
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.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

The Reporting Services logs mostly just repeat that “The Report Server Windows service ‘ReportServer’ is not running.” …

This issue was caused by a windows hotfix - KB948109, it changed Windows Internal Database (WYukon) security settings that could make the service start timeout.

There are 2 ways can make it resolved.

Solution A: Use Add/Remove to uninstall this hotfix KB948109.

Solution B: Change the registry to increase the timeout value.

We suggest Solution B.

To increase the timeout value in the registry, follow these steps:

  1. Start Registry Editor (Regedit.exe).
  2. To change the value data for the ServicesPipeTimeout DWORD value to 60000 in theControl key, follow these steps:
    1. Locate and then click the following registry key:
      HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet
    2. Click the Control subkey
    3. Right-click the ServicesPipeTimeout DWORD value, and then click Modify.
    4. Click Decimal.
    5. Type 60000, and then click OK.
  • If the ServicesPipeTimeout value is not available, add the new DWORD value, and then set its value data to 60000 in the Control key. To do so, follow these steps:
    1. Locate and then click the following registry key:
      HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet
    2. Click the Control subkey.
    3. On the Edit menu, point to New, and then click DWORD Value.
    4. Type ServicesPipeTimeout, and then press ENTER.
    5. Right-click the ServicesPipeTimeout DWORD value, and then click Modify.
    6. Click Decimal.
    7. Type a value of 60000, and then click OK.The value is 60000 milliseconds and is equivalent to 60 seconds or to one minute.

      Note This change does not take effect until the computer is restarted