Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    8

    Unanswered: POST SP3 Problems

    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?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    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

  3. #3
    Join Date
    Feb 2003
    Posts
    8
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •