FIX: An access violation occurs in SQL Server 2000 when a high volume of local shared memory connections occur after you install security update MS03-031

This article has been archived. It is offered "as is" and will no longer be updated.
Bug #: 470402 (SQL Server 8.0)
Microsoft distributes Microsoft SQL Server 2000 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2000 fix release.
SUMMARY
This article describes the following about this hotfix release:
  • The issues that are fixed by this hotfix package
  • The prerequisites for installing the hotfix package
  • Whether you must restart the computer after you apply the hotfix package
  • Whether the hotfix package is replaced by any other hotfix package
  • Whether you must make any registry changes
  • The files that are contained in the hotfix package
Introduction

Issues that are fixed by this hotfix package

The following issue is fixed in this Microsoft SQL Server 2000 hotfix package:
  • In SQL Server 2000, after you install the security update that is described in the following Microsoft Knowledge Base article, you may experience an access violation when a high volume of local shared memory connections occur:
    815495 MS03-031: Cumulative security patch for SQL Server
    Note The access violation causes SQL Server to shut down.

    When the access violation occurs, the following event is logged in the Application log:
    Event Type: Error
    Event Source: MSSQLSERVER
    Event Category: (2)
    Event ID: 17055
    Description:
    17310 :
    SqlDumpExceptionHandler: Process 3856 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
    When the access violation error occurs, you may notice stack information that is similar to the following:
    ChildEBP RetAddr  Args to Child              0c6cfbe8 77f46866 00c701f8 00000000 0c6cfc94 ntdll!RtlpCoalesceFreeBlocks+0x350 (FPO: [Non-Fpo]) (CONV: stdcall) [d:\srv03rtm\base\ntos\rtl\heap.c @ 6328]0c6cfcb4 77bbb9be 00c70000 00000000 0b7565d0 ntdll!RtlFreeHeap+0x2e9 (FPO: [Non-Fpo]) (CONV: stdcall) [d:\srv03rtm\base\ntos\rtl\heap.c @ 3685]0c6cfcfc 0c412494 0b7565d0 00000000 c000021f MSVCRT!free+0xc3 (FPO: [Non-Fpo]) (CONV: cdecl) [d:\srv03rtm\base\crts\crtw32\heap\free.c @ 169]0c6cff90 0bfc2c21 0b7308b0 0b74c2d0 0000057c SSmsLPCn!ConnectionAccept+0x4f1 (CONV: cdecl) [..\..\..\nt\lpc\src\lpcs.c @ 1386]0c6cffb8 77e4a990 00000000 00000000 00000000 SSNETLIB!Accept_LPCThread+0xbc (CONV: cdecl) [..\..\..\nt\ssock\src\ntssocks.c @ 1783]0c6cffec 00000000 0bfc2b65 00000000 00000000 kernel32!BaseThreadStart+0x34 (FPO: [Non-Fpo]) (CONV: stdcall) [d:\srv03rtm\base\win32\client\support.c @ 533]
For a list of previous hotfixes, see the "Microsoft SQL Server 2000 Post-Service Pack 3 or Microsoft SQL Server 2000 Post-Service Pack 3a hotfixes" section in the following Microsoft Knowledge Base article:
290211 How to obtain the latest SQL Server 2000 service pack
RESOLUTION

Service pack information

For more information about the latest service pack for Microsoft SQL Server 2000, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack

Hotfix information

Prerequisites

You must have Microsoft SQL Server 2000 Service Pack 3 (SP3) installed to apply this hotfix. For more information about how to obtain SQL Server 2000 Service Pack 3, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack

Restart information

You do not have to restart the computer after you apply this hotfix.

Registry information

You do not have to make any changes to the registry.

Hotfix file information

This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may not contain of all the files that you must have to fully update a product to the latest build.

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
SQL Server 2000 32-bit versions
   Date         Time   Version        Size       File name   ------------------------------------------------------------------   18-Sep-2003  16:05  8.0.21213.0      352,256  Msvcr71.dll         18-Sep-2003  16:05  2000.80.796.0     57,904  Osql.exe            18-Sep-2003  16:05  2000.80.534.0    127,548  Sqdedev.dll         18-Sep-2003  16:05  2000.80.194.0    180,290  Sqlunirl.dll        31-May-2003  18:45  2000.80.818.0     78,400  Console.exe         02-Oct-2003  20:59  2000.80.867.0     33,340  Dbmslpcn.dll        25-Apr-2003  02:12                   786,432  Distmdl.ldf   25-Apr-2003  02:12                 2,359,296  Distmdl.mdf   30-Jan-2003  01:55                       180  Drop_repl_hotfix.sql   12-Sep-2003  03:26  2000.80.859.0  1,905,216  Dtspkg.dll          26-Aug-2003  20:16  2000.80.854.0    528,960  Dtspump.dll         23-Jun-2003  22:40  2000.80.837.0  1,557,052  Dtsui.dll           23-Jun-2003  22:40  2000.80.837.0    639,552  Dtswiz.dll          24-Apr-2003  02:51                   747,927  Instdist.sql   03-May-2003  01:56                     1,581  Inst_repl_hotfix.sql   08-Feb-2003  06:40  2000.80.765.0     90,692  Msgprox.dll         01-Apr-2003  02:07                     1,873  Odsole.sql   05-Apr-2003  01:46  2000.80.800.0     62,024  Odsole70.dll        07-May-2003  20:41  2000.80.819.0     25,144  Opends60.dll        02-Apr-2003  21:48  2000.80.796.0     57,904  Osql.exe            02-Apr-2003  23:15  2000.80.797.0    279,104  Pfutil80.dll        04-Aug-2003  18:17                   550,780  Procsyst.sql   12-Sep-2003  00:37                    12,305  Qfe469315.sql   22-May-2003  22:57                    19,195  Qfe469571.sql   06-Sep-2003  01:36                 1,090,932  Replmerg.sql   06-Sep-2003  07:18  2000.80.858.0    221,768  Replprov.dll        06-Sep-2003  07:18  2000.80.858.0    307,784  Replrec.dll         06-Sep-2003  00:00                 1,087,150  Replsys.sql   13-Aug-2003  16:28                   986,603  Repltran.sql   29-Jul-2003  20:13  2000.80.819.0    492,096  Semobj.dll          31-May-2003  18:27  2000.80.818.0    172,032  Semobj.rll   05-Aug-2003  21:06                   127,884  Sp3_serv_uni.sql   01-Jun-2003  01:01  2000.80.818.0  4,215,360  Sqldmo.dll          07-Apr-2003  17:44                    25,172  Sqldumper.exe       19-Mar-2003  18:20  2000.80.789.0     28,672  Sqlevn70.rll   27-Sep-2003  04:42  2000.80.865.0    180,792  Sqlmap70.dll        03-Sep-2003  02:56  2000.80.857.0    188,992  Sqlmmc.dll          02-Sep-2003  23:03  2000.80.857.0    479,232  Sqlmmc.rll   08-Feb-2003  06:40  2000.80.765.0     57,920  Sqlrepss.dll        30-Sep-2003  01:24  2000.80.866.0  7,606,353  Sqlservr.exe        25-Jul-2003  21:44  2000.80.845.0    590,396  Sqlsort.dll         08-Feb-2003  06:40  2000.80.765.0     45,644  Sqlvdi.dll          02-Oct-2003  20:59  2000.80.867.0     33,340  Ssmslpcn.dll        01-Jun-2003  01:01  2000.80.818.0     82,492  Ssnetlib.dll        01-Jun-2003  01:01  2000.80.818.0     25,148  Ssnmpn70.dll        01-Jun-2003  01:01  2000.80.818.0    158,240  Svrnetcn.dll        31-May-2003  18:59  2000.80.818.0     76,416  Svrnetcn.exe        30-Apr-2003  23:52  2000.80.816.0     45,132  Ums.dll             02-Jul-2003  00:19  2000.80.834.0     98,816  Xpweb70.dll         12-Sep-2003  03:26  2000.80.859.0  1,905,216  Dtspkg.dll          23-Jun-2003  22:40  2000.80.837.0  1,557,052  Dtsui.dll           23-Jun-2003  22:40  2000.80.837.0    639,552  Dtswiz.dll          02-Apr-2003  21:48  2000.80.796.0     57,904  Osql.exe            02-Apr-2003  23:15  2000.80.797.0    279,104  Pfutil80.dll        29-Jul-2003  20:13  2000.80.819.0    492,096  Semobj.dll          31-May-2003  18:27  2000.80.818.0    172,032  Semobj.rll   01-Jun-2003  01:01  2000.80.818.0  4,215,360  Sqldmo.dll          07-Apr-2003  17:44                    25,172  Sqldumper.exe       03-Sep-2003  02:56  2000.80.857.0    188,992  Sqlmmc.dll          02-Sep-2003  23:03  2000.80.857.0    479,232  Sqlmmc.rll   01-Jun-2003  01:01  2000.80.818.0    158,240  Svrnetcn.dll        31-May-2003  18:59  2000.80.818.0     76,416  Svrnetcn.exe     
Note Because of file dependencies, the most recent hotfix or feature that contains these files may contain additional files.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.
MORE INFORMATION
For more information about the naming schema for Microsoft SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
822499 New naming schema for Microsoft SQL Server software update packages
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
SQL2000 AV
Properties

Article ID: 830366 - Last Review: 01/17/2015 05:25:36 - Revision: 2.3

  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000, Workgroup Edition
  • Microsoft SQL Server 2000 Desktop Engine (Windows)
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit
  • kbnosurvey kbarchive kbhotfixserver kbhotfixserver kbsqlserv2000presp4fix kbbug kbfix kbqfe KB830366
Feedback