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.

CAUSE:
Certificates that exist on the server.
Certificates install for various reasons. The most common are:

* Certificates you use to sign e-mail digitally.

* Certificates you use on a wireless network for security reasons.

SOLUTION:

1. Hard RESTART the SQL server
2. or try http://support.microsoft.com/kb/309398