Just had my excitement for the afternoon.
Had the Implementation Team install some database drivers from Merant/DataDirect onto a Windows 2003 Server with SQL Server 2000 sp3 patched to 952.
Box was rebooted and BINGO!
All the instances of SQL Server startup and die with “FRunCM: Process xxxx generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.”
OK, Re-Installed MDAC 2.8. No luck.
Installed a new instance of SQL Server. It dies on SP3 installation.
Well, after much hunting, it turns out that the 3rd party driver decided to install in it’s own directory and register an old version of sqloledb.dll. Once I re-registered the most recent one in C:\Program Files\Common Files\System\Ole DB, everything is happy again.
Like a good boy, I did this in the Test environment, long before it was to go into Production environments.