yesterday everything was set my application was running fine but suddenly at midnight the MSSQL 2005 server start giving me an error saying error 40
so i have quickly search the net to solve this up and i got a blog which says go to your configuration manager and check whether MSSQL service is running , so i went there and check the service was not running so i started it, but it fails to start
i have not changed anything and I m just connecting my application to the database and both are local (no remote connection at all)
can any one explain me why this problem occurs and to be more specific how to solve this problem in couple of minutes because i hate that error message.

what is in the SQL Server errorlog file?

thanks for the reply but that was my friends laptop and now i don't have it to check whats there in the log file
cant you provide help with just the error message

Sorry. My crystal ball is not working.

We are somewhat limited, because in order to help you resolve an error 40 where the SQL Server service does not start we need to see the errorlog file to determine what the problem/solution is.

-PatP

-Is the disk out of space
-did the password change for the account running sql server
-did someone delete a file they weren't supposed to
-did someone change the default database then drop it
the list goes on, need those logs
try using eventvwr.msc applicationm log you will see the event
should give you a good idea as t o where to start