Microsoft KB Archive/919710

= Error message when you try to connect to an instance of SQL Server 2005: &quot;No process is on the other end of the pipe&quot; or &quot;An existing connection was forcibly closed by the remote host&quot; =

Article ID: 919710

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Express Edition with Advanced Services
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Standard X64 Edition

-





SYMPTOMS
Consider the following scenario. An instance of Microsoft SQL Server 2005 is installed on a computer that is running Microsoft Windows XP or Microsoft Windows 2000. You try to connect to the instance. In this scenario, you receive one of the following error messages depending on the protocol that you use for the connection:  When you try to connect to the instance by using the named pipes protocol or the shared memory protocol, you receive the following error message:

No process is on the other end of the pipe.

 When you try to connect to the instance by using the TCP/IP protocol, you receive the following error message:

An existing connection was forcibly closed by the remote host.





CAUSE
This problem occurs because a certificate that has the AT_SIGNATURE key specification is used for Secure Sockets Layer (SSL) encryption for the instance. A certificate that has the AT_SIGNATURE key specification cannot be used for SSL encryption in SQL Server 2005. On a computer that is running Microsoft Windows Server 2003, the certificate is recognized as not valid. Therefore, the SQL Server service does not load the certificate, and the service does not start. However, on a computer that is running Windows XP or Windows 2000, the SQL Server service loads the certificate, and the service starts successfully. This behavior causes the connection to fail.



RESOLUTION
To resolve this problem, use a valid certificate. You must use a certificate that has the AT_EXCHANGE key specification.

You can examine the key specification of the certificate by using the Certutil utility (Certutil.exe). To do this, follow these steps:  At a command prompt, run the following command:

Certutil -store -v my - 

Note In this command,  is a placeholder for the serial number of the certificate that you specify for the instance. To obtain the serial number of the certificate, locate the following registry subkey, and then obtain the value of the Certificate registry entry:

 In the result text, locate a section that resembles the following:

CERT_KEY_PROV_INFO_PROP_ID(2):

Key Container = c3748a7420955ed4ee1dffb26484a0df_64756357-bf11-4528-b106-59c407d8a6e8

Provider = Microsoft RSA SChannel Cryptographic Provider

ProviderType = c

Flags = 60

KeySpec = 1

For a valid certificate, the KeySpec property has a value of 1. If the KeySpec property has a value of 2, the certificate has the AT_SIGNATURE key specification. Therefore, you experience the problem that is mentioned in the &quot;Symptoms&quot; section when you use the certificate.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
We strongly recommend that you use SQL Server Configuration Manager to specify a certificate for an instance. SQL Server Configuration Manager displays only the certificates that are valid for use by the server. Therefore, you can avoid selecting a certificate that is not valid.

Keywords: kbtshoot kbprb kbexpertiseadvanced kbsql2005engine kbsql2005connect KB919710

-

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

© Microsoft Corporation. All rights reserved.