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
MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008
Event Viewer will show the following events:
Event 1Event Type: ErrorEvent Source: Service Control ManagerEvent Category: NoneEvent ID: 7000The 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 2Event Type: ErrorEvent Source: Service Control ManagerEvent Category: NoneEvent 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
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
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:
Reporting Services Support Engineer