Re: How to (completely) turn off protocol encryption in SQL Server? (the checkbox in server network utility is unchecked)

From: Ron (ron.bennatan_at_gmail.com)
Date: 03/28/05 

Date: 28 Mar 2005 07:14:27 -0800

Hi Jasper,

Thanks for the reply.

First - in answer to your question - it is conflicting with some
existing policies and signatures in an IDS (intrusion detection system)
and I'm trying to help a client figure this out.

I undestand your reply and that's what I suspected, but there is still
one thing I don't understand. In trying to figure this out I instaleld
a brand new box, and put the CA and SQL Server on it. I had a root
certificate and everything but SQL Server was not affected - i.e. the
handshake was normal. Only when I turned on protocol encryption and
installed a certificate with the machine's name under the root
certificate did the encryption start. Now I'm trying to revert back to
the original - and that's what I'm unseceessful doing.

Is there a way to do this other than reinstall SQL Server?

Thanks,
-Ron

Relevant Pages

  • HOWTO: SQL Server SSL On A Cluster
    ... This post describes issues concerning the implementation of SSL ... certificates on SQL Server 2000 clusters. ... cluster and failover is working, ... DC is running a certificate authority, and that the CA is configured ...
    (microsoft.public.sqlserver.clustering)
  • HOWTO: SQL Server SSL On A Cluster
    ... This post describes issues concerning the implementation of SSL ... certificates on SQL Server 2000 clusters. ... cluster and failover is working, ... DC is running a certificate authority, and that the CA is configured ...
    (microsoft.public.sqlserver)
  • Re: SQL Server 2005 SP2 fails in upgrading Database service
    ... Clearing the certificate had no success. ... I suspect there's a problem with the permissions of the SQL Server service ... SQL Server Database Services 2005 ENU SP2 ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 SP2 fails in upgrading Database service
    ... Clearing the certificate had no success. ... I suspect there's a problem with the permissions of the SQL Server service ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.setup)
  • Re: Certificate chain issue with Ent Sub Ca & stand alone Root CA
    ... certificate and I get a "Cannot verify certificate chain. ... revocation because the revocation server was offline. ... the root ca? ... Online>>> Online Enterprise Subordinate CA ...
    (microsoft.public.windows.server.security)