Fresh install of Win2K Server with all the latest Services Packs and Patches.
Fresh Install of SQL Servers 2000
Everything works OK
SQL Services Manager runs for 1 second and closes
Running New SQL Server Registration Wizard in Enterprise Manger, after hitting Next on the first screen Enterprise Manager goes poof and closes
DR. Watson Error:
Event Type: Information
Event Source: DrWatson
Event Category: None
Event ID: 4097
Time: 8:38:37 AM
The application, mmc.exe, generated an application error The error occurred on 02/14/2003 @ 08:38:37.458 The exception generated was c0000005 at address 780011CD (wcslen)
Has anyone else experienced this error, or know how I can correct it?
I have experienced a different error (possibly related)
Windows 2K box
SQL 2K sp2
Add SQL SP3
SQL Server process crashes on any extended stored procedure execution. Some DBCC commands (checkdb but not showcontig) also crash the server process.
I talked to Microsoft about it, and it seems that there is one MDAC hotfix that will report a successful installation no matter what. Out of 4 machines, I only had one go bad, but I still have 30 to go....
The fix in my case was as follows:
1) run C:\SQL2KSP3\x86\other\sqlredis.exe /t:C:\Extract /c
2) run C:\Extract\mdac_qfe.exe
3) Re-run SQL SP3 setup
It fixed my particular problem, but I don't know if it will do anything to yours. Can you run extended stored procs in Query Analyzer?