Windows 2003 Server and MS SQL 2000 not playing nice

[CefiroZ]

I have a windows 2003 server box that runs MS SQL 2000 for our company. I have SQL server updated to SP4 currently. The problem I'm having is that when I apply SP1 to Win2003 my SQL Server will not run. I get the following errors in the application log:

17310 :
SqlDumpExceptionHandler: Process 3216 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

17311 :
SQL Server is aborting. Fatal exception c0000005 caught.

Does anyone know how I can fix this?

 

[Messy]

unfortunately, i don't have any real help, but personally i would rollback sp1

is there anything in particular that you gain from sp1? database servers, when working properly, are better left alone.

 

[BGM]

unfortuantley those erros looks very generic and unhelpful :/


i have patched lots of our servers at work with win2k3 sp1 and they all run sql server2000 fine

(every server we have runs sql2000, and all the laptops too!)

id advise you backup your database, rebuild the server to sp1, and patch the database to sp4, THEN see if it errors? if not load your backups in again

better if you have a spare machine to test it on

 

[BGM]

oh also, make sure you stop all processes that are not windows related (this means slq2000) when you patch windows... that might cause a problem although iv not had it

good luck!

 

[j4zzee]

Is this an Event ID 17055, with the SQL Error description being 17310?
Have you checked the SQL Logs for a more complete dump report?
Sort your event log by source "MSSQLSERVER" and check for more related errors.