Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting Service Fails to Start Expand / Collapse
Author
Message
Posted Monday, March 17, 2008 1:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 23, 2013 1:20 PM
Points: 36, Visits: 40
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



Post #470451
Posted Monday, March 17, 2008 2:24 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:53 PM
Points: 10,277, Visits: 13,257
Is IIS starting? Is the reporting service on the same server as sql server?



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #470502
Posted Monday, March 17, 2008 11:59 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 23, 2013 1:20 PM
Points: 36, Visits: 40
Hi Jack,
The RS services are on the same machine as the SQL services. IIS is running fine.

Rgds, Scott



Post #470644
Posted Tuesday, March 18, 2008 12:23 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,406, Visits: 1,400
Shut down the server again and restart everything in proper sequence. Most likely the problem will go.

:)



Post #470652
Posted Tuesday, March 18, 2008 2:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 23, 2013 1:20 PM
Points: 36, Visits: 40
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!



Post #470672
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse