SQL Server does not exist or access denied

Okay...Running SQL Server 2000 & yesterday I was inside of Query Analyzer keying away with no problems. Exited out of everying like normal, powered my laptop down & life was good.
Or so I thought.
I started my laptop today & my SQL Server Services Manager shows that my SQL Server is not running.
Long story short, I've torn this thing apart and can't figure out why it's not running. My Client Network Utility has Named Pipes & TCP/IP Enabled. TCP/IP has port 1433 enables. As for my named pipes, those are jacked cuz I've tried everything I can think of to get it working so I will need to know what goes in there as well.
My Server Network Utility has the same, Named Pipes & TCP/IP enabled (in that order).
I've tried switching the order, nothing.
What I'm trying to do initially is get My "MSSQLSERVER" service to start and my "SQLSERVERAGENT" as well. In my past experiences if I get those 2 running, everything else falls into place. Then I'm back into Query Analyzer coding away.

I've had this happen 1 time before & the only way for me to fix it was to uninstall SQL Server & reinstall it. Worked fine after that. This time I would like to think there's something I can do short of uninstalling/reinstalling.

Answer this question

SQL Server does not exist or access denied

timay
Went into my Program Files\Microsoft SQL Server\[Instance Name]\Log\Errorlog subdirectory to look at the errorlogs. I don't know why I didn't look here sooner. Would have saved me a TON of time. I went to this log subdirectory, opened up ErrorLog & find this:

"2005-12-21 19:27:46.60 server SQL Server evaluation period has expired"

<sarcasm> Thanks Microsoft for the loud & obnoxious warning that my evaluation period has expired! </sarcasm>

*sigh* It's late. Will reinstall the software tomorrow & put a warning in my pda that in 120 days this will happen again.

Thanks to all who replied.
hbcondo

SQL Server is not one of the services that is supposed to stop when there is no work for it to do.

There should be a shortcut to SQL Server Configuration Manager in Start | All Programs | Microsoft SQL Server 2005 | Configuration Tools.
Amol Gholap
Almost a year has passed since you posted this expiry problem, but I have the same problem now. I do hope you read this message..

My question...'Is it possible to extend the evaluation copy of SQL server by re-installing '

Did you manage to do it

Thanks

Peter webmaster@elooker.co.uk
DingW
When I try to start MSSQLSERVER in Services (manually, even though it's set for Automatic) I get "The MSSQLSERVER service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

As for running the SQL Server Config manager, that's not in my SQL Server folder. How do I access that I'm using SQL Server 2000.
Bill52
Have you tried running SQL Server Configuration Manager and starting the SQL Serve service What error message are you getting when the service fails to start
SQL Server does not exist or access denied

Answer this question