Reporting Service Fails to Start
-
After a server reboot the ReportServer service is failing to start on a boc 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
5. Saw that sa account was locked out for some reason: reset password and account now looks fine
Any ideas? I have a production site down with this problem and I am desperate
-
Is IIS starting? Is the reporting service on the same server as sql server?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Hi Jack,
The RS services are on the same machine as the SQL services. IIS is running fine.
Rgds, Scott
-
Shut down the server again and restart everything in proper sequence. Most likely the problem will go.
-
Thanks guys, the problem has been resolved. We made two changes prior to the last server reboot:
1.Changed the service timeout from 30000 to 120000 (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2776350&SiteID=1)
2.We found a DCOM security issue on the server, so we granted Local Activation permission to the Network Connection Manager Class {BA126AD1-2166-11D1-B1D0-00805FC1270E} to the user NT AUTHORITY\NETWORK SERVICE, as suggested in the event log
Not too sure which step actually fixed it - or if another reboot was all that was required?
Thanks again!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply