Does anybody know why?

Hi gurus,
Recently, my SQL Server Machine is suffering auto shutdown.
After the auto shutdown, and restart of the machine, I found that the file
under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
could not be started if I didn't change it back to SSNETLIB.DLL. But after a
while (usually minutes to tens of minutes), it will auto shutdown again. If
I didn't not rename it, there will be no auto shutdown.
My SQL Server was MSDN developer edition, with SP3 applied.
My machine is Windows 2000 professional edition with the latest patches
installed.
Please help me out
Thanks in advance
FrankFrank wrote:
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the
> file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> SQL Server could not be started if I didn't change it back to
> SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> it will auto shutdown again. If I didn't not rename it, there will be
> no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest
> patches installed.
> Please help me out
> Thanks in advance
> Frank
Do you have your PC set to reboot on errors? Check to see your settings
in My Computer | Advanced | Startup and Recovery. It might give you
additional information if you also check the Application and System
event logs.
--
David Gugick
Imceda Software
www.imceda.com|||Thanks David,
I checked my PC and found the setting in my PC was set to reboot on errors.
Now I unchecked this option and am waiting for the result.
BTW, could there be any side effect unchecking it?
Thanks again
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> > Hi gurus,
> > Recently, my SQL Server Machine is suffering auto shutdown.
> >
> > After the auto shutdown, and restart of the machine, I found that the
> > file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> > SQL Server could not be started if I didn't change it back to
> > SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> > it will auto shutdown again. If I didn't not rename it, there will be
> > no auto shutdown.
> >
> > My SQL Server was MSDN developer edition, with SP3 applied.
> > My machine is Windows 2000 professional edition with the latest
> > patches installed.
> >
> > Please help me out
> > Thanks in advance
> > Frank
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||David,
Unfortunately, it doesn't work, the PC still auto-shutdown. And after
restart, the file was changed again to SSNETLIB.OLD.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> > Hi gurus,
> > Recently, my SQL Server Machine is suffering auto shutdown.
> >
> > After the auto shutdown, and restart of the machine, I found that the
> > file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> > SQL Server could not be started if I didn't change it back to
> > SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> > it will auto shutdown again. If I didn't not rename it, there will be
> > no auto shutdown.
> >
> > My SQL Server was MSDN developer edition, with SP3 applied.
> > My machine is Windows 2000 professional edition with the latest
> > patches installed.
> >
> > Please help me out
> > Thanks in advance
> > Frank
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Frank wrote:
> David,
> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> restart, the file was changed again to SSNETLIB.OLD.
> B/R
> Frank
I can't figure out why the PC is rebooting or why the file is being
renamed. Sounds almost like you have a virus on the PC. You might be
infected with slammer. See this:
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Frank,
Still the same thing I suggested to you a month ago -
look at what's in your startups with msconfig and check the
Software\Microsoft\Windows\CurrentVersion\Run
keys in the registry,
Try reapplying SP3.
Did you do all of these?
Sue
On Thu, 3 Mar 2005 23:06:40 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Frank wrote:
>> David,
>> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
>> restart, the file was changed again to SSNETLIB.OLD.
>> B/R
>> Frank
>I can't figure out why the PC is rebooting or why the file is being
>renamed. Sounds almost like you have a virus on the PC. You might be
>infected with slammer. See this:
>http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en|||Sue,
Thanks but I have to say month ago, I did posted for help the same help, but
I got no answer at that time. From your mail, I think there must be
something wrong with the system so I didn't see your reply.
I checked the system with msconfig, and all the values in the startup panel
are known programs.
I have also followed your suggestion to reapply the SP3, but still no use.
One thing I think should let you know is that the auto-shutdown and rename
happened only after I applied some Windows patches which our company
dispatched via the SMS system.
I could not know exactly what those patches numbers are, and what they did
to the system.
Thanks
Frank
"Frank" <wangping@.lucent.com> wrote in message
news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the file
> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
> could not be started if I didn't change it back to SSNETLIB.DLL. But after
a
> while (usually minutes to tens of minutes), it will auto shutdown again.
If
> I didn't not rename it, there will be no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest patches
> installed.
> Please help me out
> Thanks in advance
> Frank
>|||David,
Thanks,
I read the article you linked and found it works for the SQL Server that
doesn't have SP2 or later applied, my SQL Server has already had the SP3
applied.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OXEWR%23GIFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Frank wrote:
> > David,
> > Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> > restart, the file was changed again to SSNETLIB.OLD.
> > B/R
> > Frank
> I can't figure out why the PC is rebooting or why the file is being
> renamed. Sounds almost like you have a virus on the PC. You might be
> infected with slammer. See this:
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Also check the registry keys - a lot of viruses that
reinstall have install in the CurrentVersion\Run keys.
If it's something from a patch delivered with SMS, the
history of what is pushed out to what server, clients is in
SMS. I can't remember if there is a predefined report for
that or if you have to figure out what tables and write your
own query.
You'd also want to check the event logs as David suggested.
You may also want to check for a dump file - the type of
dump and the location of the file is set in properties on
the Startup and Recovery window were you just were to change
the setting to not restart on errors.
-Sue
On Mon, 7 Mar 2005 10:48:19 +0800, "Frank"
<wangping@.lucent.com> wrote:
>Sue,
>Thanks but I have to say month ago, I did posted for help the same help, but
>I got no answer at that time. From your mail, I think there must be
>something wrong with the system so I didn't see your reply.
>I checked the system with msconfig, and all the values in the startup panel
>are known programs.
>I have also followed your suggestion to reapply the SP3, but still no use.
>One thing I think should let you know is that the auto-shutdown and rename
>happened only after I applied some Windows patches which our company
>dispatched via the SMS system.
>I could not know exactly what those patches numbers are, and what they did
>to the system.
>Thanks
>Frank
>"Frank" <wangping@.lucent.com> wrote in message
>news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
>> Hi gurus,
>> Recently, my SQL Server Machine is suffering auto shutdown.
>> After the auto shutdown, and restart of the machine, I found that the file
>> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
>> could not be started if I didn't change it back to SSNETLIB.DLL. But after
>a
>> while (usually minutes to tens of minutes), it will auto shutdown again.
>If
>> I didn't not rename it, there will be no auto shutdown.
>> My SQL Server was MSDN developer edition, with SP3 applied.
>> My machine is Windows 2000 professional edition with the latest patches
>> installed.
>> Please help me out
>> Thanks in advance
>> Frank
>>
>