SSL Security error -ConnectionOpen(SECDoClientHandshake)

External Since: Jun 17, 2004 Posts: 2

Please help.
On my default instance of SQL Server 2000, which could be accessed OK with
both Windows and SQL server authentication, I now get the error in the
subject line above.
The message in the error window - in SQL server enterprise manager- suggest
to verify the SQL server registration, but there is nothing that will make
it work.
The password did not change, and now windows authentication does not let me
in either.
Where could I look for parameters to change other than the password and user
name that have to do with SSL security.
This happened just after I installed an SSL certificate for SQL Reporting
Services on the local IIS, and then deployed the sample reporting services
solution that comes with Reporting Services to the IIS. But this should not
have changed my default sql server registration parameters, because the sql
server that services reporting services is a different instance and it is
still working and can be accessed OK.
Thanks.

External Since: Dec 12, 2003 Posts: 219

Sounds like the cert on the server is being read on startup.

Client --->SQL/Reporting Serve/IIS

Is this your scenario?

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.