Log in  \/ 
x
x
x
Register  \/ 
x

16
July
2013

SQL Server Reporting Services not started

Assume that you apply the update that is described in Microsoft Knowledge Base (KB) article 2677070 on a computer that is running Microsoft SQL Server Reporting Services (SSRS). When you try to start SSRS, you receive a time-out error, and event ID 7000 and event ID 7009 are logged in the Application log.

This issue occurs because of an inability to retrieve trusted and untrusted certificate trust lists (CTLs). If the system does not have access to Windows Update, either because the system is not connected to the Internet or because Windows Update is blocked by firewall rules, the network retrieval times out before the service can continue its startup procedure. In some cases, this network retrieval time-out may exceed the service startup time-out of 30 seconds. If a service cannot report that startup completed after 30 seconds, the service control manager (SCM) stops the service.

To work around this problem, configure the computer so that the network does not retrieve trusted and untrusted CTLs.

Increase the default service time-out. 

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: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
  3. Right-click Control, point to New, and then click DWORD.
  4. In the New Value box, type ServicesPipeTimeout, and then press Enter. 
  5. Right-click ServicesPipeTimeout, and then click Modify.
  6. Click Decimal, type the number of milliseconds that you want to wait until the service times out, and then click OK. For example, to wait 60 seconds before the service times out, type 60000.
  7. On the File menu, click Exit, and then restart the computer.

Categories: System Center 2012 Operations Manager

scsm guru

Leave a comment

You are commenting as guest.

This is the default dialog which is useful for displaying information. The dialog window can be moved, resized and closed with the 'x' icon.