• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2208
  • Last Modified:

SQL Server Reporting Services (MSSQLSERVER) wont automatically start !

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
Description:
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 http://go.microsoft.com/fwlink/events.asp.

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
Description:
Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
cuteo408
Asked:
cuteo408
1 Solution
 
tigin44Commented:
did you check the log on user and credentials of the service...
0
 
chapmandewCommented:
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.
0
 
cuteo408Author Commented:
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 ASP.net version 1.1 and  ASP.net 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 ASP.net at the sametime. If I set all the services to use ASP.net 2.0 then it's fine. But one of sharepoint app wont let me set to 2.0.

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

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now