Help: SQL Server 2000 failed to restart after NT Server reboot

Hi,
We have a NT Server that's set to reboot every weekend. SQL server
2000 and SQL Server Agent were set to auto-restart after reboot. It's
been working fine for a long time.
But several weeks ago,both SQL server and SQL server agent didn't
restart after the reboot so all DTS jobs didn't run until we manually
restart the Server and the server agent. We didn't receive any error
message and event log didn't
have any error either. It did show the SQL server was shut down by
request and the server agent was stoped successfully. But there's no
log about the server starting and ready for client connection. The
services are set with local system account.
We have a utility to check the connection to the server and it came
back with error of "[Shared Memory]SQL Server does not exist or access
denied. [Shared Memory]ConnectionOpen (Connect())"
If the SQL server was never asked to restart by the OS, what could be
the reason and how can I fix it?
Thanks a lot.
Ping LiWhat are you getting with issuing the command OSQL -L at the
commandline. Did you try to restart the SQL Server service the Service
Panel in Windows ? If not, do so and see if the server is coming u and
if not what kind of error message you are getting here. There must be
some event log message if the SQl Server doesnt=B4start up properly
(even if it does there is an entry). Is your event log outta space ?
HTH, Jens Suessmeyer.|||Hi, Jens,
Thanks for your reply. I tried OSQL -L and the result is:
(local)
commserver\commvaultqinetix
digital
zpm
I have no idea what it means.
We were able to restart the SQL server every time it failed to start
automatically after reboot. There's no entry about the server at all.
The last entry is the sql server was shut down by request(we schedule
the task) and the server agent was stopped successfully.
There is no error about the event log out of space. Can you guess what
the possible reason for the failure? They were set to restart
automatically.
Thank you for your help.
Ping
I have no idea what it means.