Fresh install of Win2K Server with all the latest Services Packs and Patches.
Fresh Install of SQL Servers 2000
Everything works OK
Install SP3
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
Date: 2/14/2003
Time: 8:38:37 AM
User: N/A
Computer: CRUISE03
Description:
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
2a) reboot.
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?
~Matt|||Unfortunately this fix didn't work for me.
I don't having any stored procedures to test, this is a very simple setup for my new web server.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment