Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
SQL Server 2000 installation or local connections fail with "SSL Security error :ConnectionOpen (SECDoClientHandshake())" error message
Article ID: 309398 - View products that this article applies to.
This article was previously published under Q309398
When you try to install Microsoft SQL Server 2000 on a computer that has certificates, installation can fail and you may receive the following error message:
[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()).
SQL Server configuration failed.
-or-When you add certificates to a server that already has SQL Server installed, local connections fail.
Certificates that exist on the server.
Certificates install for various reasons. The most common are:
SQL Server 2000 introduces Secure Sockets Layer (SSL) encryption through the use of certificates. If SQL Server finds certificates on the local computer, SQL Server attempts to use the certificates. If the certificate is not issued to the fully qualified domain name of the computer, SQL Server considers the certificate invalid. If there are multiple certificates on the computer, there is no way to pick which certificate SQL Server must use.
You must identify the source of the certificates on the computer before you proceed. For the SQL Server 2000 installation to be successful, you must use the Microsoft Management Console (MMC) snap-in to view the certificates on your computer.
How to Use the MMC Snap-in to View CertificatesTo use the MMC snap-in to view certificates, use these steps:
To install SQL Server 2000 successfully, export the certificates to a file, and then delete the certificates from the Certificate MMC snap-in. After you successfully install SQL Server 2000:
Certificates (local computer) Personal Certificates Certificates-Current User Personal Certificates