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.
cuteo408Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.