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 "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
Keywords: kbbug kbfix kbqfe kbsqlserv2000presp4fix kbpubtypekc KB900961