Registration of SQL Server

Helo All,
We have two W2K servers. One is an SQL Server(S1) and another one is a
server (S2) on which SSL Certificate is installed.
When I try to register SQL Server from S2 through enterprises manager,
following error occured:
Encryption not supported on SQL Server| ConnectionOpen(PreLoginHandshake...
In this scenario is it mandatory to have SSL installed on the SQL Server
Machine (S1) also?
Any comment on this would be highly helpful.
Thanks in anticipation!
Warm Regards
Sathian
>
> We have two W2K servers. One is an SQL Server(S1) and another one is a
> server (S2) on which SSL Certificate is installed.
> When I try to register SQL Server from S2 through enterprises manager,
> following error occured:
> Encryption not supported on SQL Server|
ConnectionOpen(PreLoginHandshake...
> In this scenario is it mandatory to have SSL installed on the SQL Server
> Machine (S1) also?
> Any comment on this would be highly helpful.
This error indicates either sql server server thinks the certificate is
invalid
or can't locate the certificate. To check if Sql Server can use a
certificate, enable
force protocol encryption on the server side and restart the service. If
Sql Server starts then certificate is okay.
The error can also occur if you have installed the certificate on sql
server but
have not restarted sql. so even if you are using client side encryption,
you need to restart sql server once the certificate is installed.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.