Microsoft KB Archive/811887

= PRB: Error 17882 &quot;Error Accepting Connection Request via Net-Library 'SSNETLIB'. Execution Continuing&quot; When You Connect to SQL Server =

Article ID: 811887

Article Last Modified on 9/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



SYMPTOMS
When applications try to connect to SQL Server, the computer that is running SQL Server may not respond.

You may see the following error in the SQL Server error log:

2003-01-01 10:45:19.84 server Error: 17882, Severity: 18, State: 1

2002-01-01 10:45:19.84 server Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing..



CAUSE
This behavior may occur when you use system stored procedures that allow Automation objects and you use these system stored procedures in Transact-SQL batches, stored procedures, or triggers.



WORKAROUND
To work around this problem, explicitly call the sp_OADestroy stored procedure to destroy an Automation object.



MORE INFORMATION
When you use the sp_OACreate stored procedure to create an Automation object, the object is created in the SQL Server address space. If sp_OADestroy stored procedure is not used to successfully destroy the OLE object, the memory that the object is using may not be cleared. The sp_OAMethod, sp_OAGetProperty, and sp_OASetPropertyDue stored procedures may also contribute to memory leaks. Therefore, the SQL Server may run out of memory and stop responding. For additional information about how to monitor SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:

224587 HOW TO: Troubleshoot Application Performance with SQL Server

