SQL Server 2000 -- SSL Security Error

Hi

I got a small problem with Sql Server 2000 which is installed on Windows XP.

I installed it long back and it used to work fine but suddenly I got the following problem when trying to open Enterprise Manger

“Error for the SQL Server:

A Connection could not established to (Local)

Reason: SSL Security error Connection Open (SECDoClienthandshake())…”

Tried a couple of things but no luck

Hopeso someone can help me!

Thanxs
Lakshmi

as I know, this error is caused by certificates, maybe the certificates is invalid, or install for various reasons. SQL Server 2000 introduces 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.