Click here to Skip to main content
16,017,852 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi friends

I am using mssql server 2008 and when i working with this sometime this sqlserver stopped automatically. and every time i want to go to sqlserver configuration manager to start a service. i dont know what is the problem.how to fix this error?
Posted
Comments
StianSandberg 22-Apr-13 3:39am    
It's almost impossible to answer this. You have too look for multiple possible solutions.
A good place to start is to take a look at your event log to see if you can find anything there. If any service fail, it should be logged in your event log.

1 solution

Run services.msc and look for SQL Server service running in it.
Right click on the service and see the properties. The Startup Type is supposed to be "Automatic". If it's not automatic you have to change it, otherwise check the event log for the startup failure.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900