Microsoft KB Archive/900961

= 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 =

Article ID: 900961

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine (Windows)
 * 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
 * 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 &quot;Applies to&quot; 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

Keywords: kbbug kbfix kbqfe kbsqlserv2000presp4fix kbpubtypekc KB900961

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.