- 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.
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 -CertificateSerialNumberNote In this command, CertificateSerialNumber 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:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib
- In the result text, locate a section that resembles the following: CERT_KEY_PROV_INFO_PROP_ID(2):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 "Symptoms" section when you use the certificate.
Key Container = c3748a7420955ed4ee1dffb26484a0df_64756357-bf11-4528-b106-59c407d8a6e8
Provider = Microsoft RSA SChannel Cryptographic Provider
ProviderType = c
Flags = 60
KeySpec = 1