SQL Server Reporting Services (MSSQLSERVER) wont automatically start !

Posted on 2008-11-11
Last Modified: 2012-06-27
I just upgrade my SBS 2003 from standard to premium. Actually, I didn't upgrade everything, only installed SQL SERVER Workgroup from the Premium CD. The process when pretty well and then I restarted my computer and got a message popup on the screen right at the login screen ( the screen where you type in your password). The popup message says that one of the event couldn't start, please check the event viewer. But when I look into the event viewer I dont see anything error/warning relating to an event couldn't start. However, when I check the Service list and saw that SQL Server Reporting Services (MSSQLSERVER) should automatically start but didn't. so I started the SQL Server Reporting service and restarted my server but still get the same message, do you have any suggestion ? I dont mind start the service everything the server restart but I am sure that something is wrong that's why that service won't start.  

I found the message in the event viewer.

Event Type:      Error
Event Source:      Service Control Manager
Event Category:      None
Event ID:      7000
Date:            11/8/2008
Time:            11:18:11 AM
User:            N/A
Computer:      SVR-DELL
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.

For more information, see Help and Support Center at

Event Type:      Error
Event Source:      Service Control Manager
Event Category:      None
Event ID:      7009
Date:            11/8/2008
Time:            11:18:11 AM
User:            N/A
Computer:      NPI-SVR-DELL
Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect.

For more information, see Help and Support Center at
Question by:cuteo408
    LVL 26

    Expert Comment

    did you check the log on user and credentials of the service...
    LVL 60

    Accepted Solution

    It sounds like Reporting Services is depending on MSSQLSERVER to start.  MSSQLSERVER is the database engine, not Reporting Services.  Make sure that the SQL Server service is started.

    Author Comment

    hi Chapmandew,

    MSSQLSERVER started everytime the server reboot. It's actually working fine right now. Do you guys think it's okay to set to start manually instead of automatic so I wont get the error message from the server. Actually, do you think the server will work normally if I disable the reporting service ?

    Plus, I have a problem with version 1.1 and version 2.0. If you check the status of the report with
    //myserver/Reports & //myserver/ReportServer then my Remote Web Workplace & Outlook Web will not work. And the error message would be that I can run two at the sametime. If I set all the services to use 2.0 then it's fine. But one of sharepoint app wont let me set to 2.0.

    Where can I look for that ? And would it help ?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now