Force Protocol Encryption & Trusted Root Authority

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

  • Next message: Sue Hoegemeier: "Re: Win Auth. - How do I prevent direct user access" 
    Date: 26 Sep 2004 19:14:31 -0700

    Hi, I just recently set up a SQL 2000 server and have a question about
    the "Force Protocol Encryption" setting.

    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.

    Thanks for any help you guys can provide!!!

  • Next message: Sue Hoegemeier: "Re: Win Auth. - How do I prevent direct user access"

    Relevant Pages