Force Protocol Encryption - Please help!

From: canuck (canada2usa_at_hotmail.com)
Date: 09/28/04

  • Next message: Jerry: "Looking for a script to audit user table rights" 
    Date: Tue, 28 Sep 2004 07:51:29 -0700

    Hi, I just recently set up a SQL 2000 server and have a question about
    the "Force Protocol Encryption" setting... can someone please help me!

    I installed my SQL server on a standalone W2K server which is NOT a
    member of a domain. I want to ensure that all connections to the SQL
    server are encrypted, so I enabled the Force Protocol Encryption
    setting. In order to make it work, I installed Certification Autority
    services on the same server, generated my SQL service account a
    certificate & installed the cert on the server.

    After installing the cert, I was once again able to start my SQL
    server and it appears that all is well, however I am concerned about
    whether or not the connections are actually being encrypted. Do my
    clients need to trust the Certificate Authority that the cert was
    generated on for the encryption to work? I read some Microsoft
    support articles about this issue and they don't seem that clear on
    this issue.

    Is there anything special that needs to be done on the clients & does
    anyone know of a way to verify that the connection is encrypted?

    Thanks for any help you guys can provide!!!

  • Next message: Jerry: "Looking for a script to audit user table rights"

    Relevant Pages