If you install MS08-040 or MS08-052 and you find that the Report Server cannot start any more, you might be facing a known issue with KB954606 and KB948109 which is preventing the SQL Reporting Services service from starting. The security update is the one outlined in the following link:

 

MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008

http://support.microsoft.com/?id=954606

or

MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008

http://support.microsoft.com/kb/948109

 

Event Viewer will show the following events:


Event 1
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000

The ServiceName service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

Event 2
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7011

 

This issue has been reported to Microsoft Support numerous times and has been passed on to developer’s team.

 

One solution would be to increase the default time-out value for the service control manager as per the below article (Please first verify that you see the events 7000 and 7011):

 

A service does not start, and events 7000 and 7011 are logged in Windows Server 2003

http://support.microsoft.com/?id=922918

 

Another solution would be to uninstall the fix and install Cumulative Update 10 for SQL Server 2005 Service Pack 2 in the Reporting Services machine that contains a later version than the partch. You can get it from:

 

Cumulative update package 10 for SQL Server 2005 Service Pack 2

http://support.microsoft.com/kb/956854

 

Ultimate solution

It you already have installed SP2 or higher, follow the steps bellow:

Update the lmhosts file to point crl.microsoft.com to the local address. This resolves and fails internally immediately allowing for a very quick return and the service can start normally.

To reroute CRL requests modify the hosts file(system32\drivers\etc) to include the following entry:

                127.0.0.1              crl.microsoft.com

 

Maria Esteban

Reporting Services Support Engineer