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 (830366)


The information in this article applies to:

  • 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 Enterprise Evaluation Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 2000 Desktop Engine (MSDE)
  • Microsoft SQL Server 2000 Developer Edition 64 bit
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit
Bug #: 470402 (SQL Server 8.0)
SQL Server 8.0:470402
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

Modification Type:MinorLast Reviewed:1/16/2006
Keywords:kbHotfixServer kbHotfixServer kbSQLServ2000preSP4fix kbbug kbfix kbQFE KB830366 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.