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.|||Hi
You may want to post the SQL Server log for when the server failed to
re-boot as this should have more information as to why it failed. You may
also want to see if anything was logged in the event log.
As something to test the server is available you may want to use SQL Ping
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26 you will need a
processs that parses the output to see if the given server is there.
John
"pli@.umn.edu" <pingli@.gmail.com> wrote in message
news:1128568970.436836.215890@.f14g2000cwb.googlegroups.com...
> 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 Li
>|||Hi, John,
Thanks for your reply.
As my previous posts said, there weren't any event log in the event
viewer after the shut down. The last 2 log entries were: SQL Server
was shut down by request. SQL Server agent was stopped successfully.
I couldn't find any log or information specifying why the server failed
to reboot. I'm trying to find out what the possible causes are so that
I know which direction to go. But so far nothing from the server log
showed up. It just disappeared in nowhere.
Thanks again and hope you can help.
Ping