SQL Server - SQL Report Server service fails to start

Asked By Scott Bredin on 17-Mar-08 04:14 PM
After a server reboot the ReportServer service is failing to start on a server running WIN2003 Server R2 and SQL 2005 SP1.   I am getting 2 errors in the event log:

Event ID: 7000 - 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.

Event ID: 7009 - Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect.

The service was configured to run under the LOCAL SYSTEM account

So far I have tried the following:
1. Changed the service account
2. Rebooted
3. Reloaded SSRS
4. Altered the service timeout to 60000 as per http://support.microsoft.com/?kbid=884495 
5. Saw that sa account was locked out for some reason: reset password and account now looks fine

Any other ideas?  I have a production site down with this problem and I am desperate

Link - F Cali replied to Scott Bredin on 25-Mar-08 12:12 AM

Here's a link that may be able to help you which pertains to the same error message that you are getting for a service that uses the local system service account on a Windows-2003-based computer:

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

SQL Report Server service fails to start - resolution - Scott Bredin replied to F Cali on 25-Mar-08 02:54 PM

I eventually got the service to start by increasing the timeout as per the following links:

http://support.microsoft.com/?kbid=884495

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2776350&SiteID=1

However, I couldnt figure out how this had suddenly gone wrong on the server - your link does explain the cause a little better - Thank you very much!