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: Signtool doesnt add entire chain when signing files
    ... you only need to ensure that the intermediate certificates are included in the signature so that the client can build a chain to the root. ... The root needs to be installed as a trusted root certificate on the client in order for the client to trust the certificate. ... Given that you don't have any intermediate certificates, it doesn't matter or not whether they are included in the signature so it should not matter if there is any difference between the wizard mode and the command line tool mode. ...
    (microsoft.public.platformsdk.security)