PRB: Anti-Virus Programs May Cause Named Pipes Connection Problem

This article was previously published under Q170338
This article has been archived. It is offered "as is" and will no longer be updated.
Important This article contains information that shows you how to help lower security settings or how to turn off security features on a computer. You can make these changes to work around a specific problem. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this workaround in your particular environment. If you implement this workaround, take any appropriate additional steps to help protect your system.
Symptoms
Anti-virus software running on client computers may cause Named Pipesconnections to Microsoft SQL Server to fail. The client application maystop responding, take a long time, or sometimes receive error 231,"Connection Busy." In the SQL Server error log, error 17832 "Unable to readlogin packet" may be logged. Connections to SQL Server using a differentnetwork protocol work normally.
Cause
When the client application requests to open a pipe, and if the anti-virussoftware is configured to scan all files, the anti-virus software treatsthe pipe as a file, and attempts to scan it. This results in opening thepipe is a "deny all" mode that prevents the client software from reading orwriting to the pipe while connected to the server. After the pipe is openedin this mode, the client is not able to send the login packet to theserver. This results in raising error 17832 "Unable to read login packet"in the SQL Server error log.

Other Named Pipes connections from the same client fail because the pipe isalready open in a "deny all" mode that prevents the usage of the same pipeby those connections. This scenario results in receiving error 231 "Pipebusy" or "Connection Busy."
Workaround
Warning This workaround may make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.

Important These steps may increase your security risk. These steps may also make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We recommend the process that this article describes to enable programs to operate as they are designed to, or to implement specific program capabilities. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this process in your particular environment. If you choose to implement this process, take any appropriate additional steps to help protect your system. We recommend that you use this process only if you really require this process.

To work around this problem, try the following suggestions:
  • Configure the anti-virus software to scan program files only.
  • Remove the anti-virus software and evaluate the SQL Server Named Pipes connection.
  • Contact the anti-virus vendor for suggestions on configuring the software.

virus antivirus detection WIN95 WIN-95 WIN odbc hang dblib named pipes stress
Properties

Article ID: 170338 - Last Review: 10/26/2013 17:06:00 - Revision: 5.0

  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • kbnosurvey kbarchive kb3rdparty kbnetwork kbprb KB170338
Feedback