FIX: A memory leak may occur when a client application uses the Dbmslpcn.dll shared memory network library version 2000.80.828.0 and connects to a local computer that is running SQL Server 2000 (900961)

The information in this article applies to:

Microsoft SQL Server 2000 Desktop Engine (MSDE)
Microsoft SQL Server 2000 Developer Edition
Microsoft SQL Server 2000 Enterprise Edition
Microsoft SQL Server 2000 Personal Edition
Microsoft SQL Server 2000 Standard Edition
Microsoft SQL Server 2000 Workgroup Edition
Microsoft SQL Server 2000 Developer Edition 64 bit
Microsoft SQL Server 2000 Enterprise Edition 64-bit

Bug #: 471107 (SQL Server 8.0)

SYMPTOMS

When a client application such as Sqlagent.exe tries to connect to a local computer that is running Microsoft SQL Server 2000, a memory leak in the client process may occur. This problem occurs when the client process uses the Dbmslpcn.dll shared memory network library version 2000.80.828.0.

RESOLUTION

To resolve this problem, install Microsoft SQL Server 2000 Service Pack 4 (SP4). For more information about how to obtain the latest SQL Server 2000 service pack, 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

WORKAROUND

To work around this problem, use a network library other than the shared memory network library. To do this, use one of the following methods:

Create an alias in the client network utility.
Specify the connection string to use the tcp:servername server name parameter or the np:servername server name parameter.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

313295 How to use the server name parameter in a connection string to specify the client network library

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

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 the terminology that Microsoft uses when it corrects software after it is released, 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:	Minor	Last Reviewed:	7/26/2006
Keywords:	kbSQLServ2000preSP4fix kbQFE kbfix kbbug kbpubtypekc KB900961 kbAudDeveloper kbAudITPRO