SS 2005 Network Configuration - Force encryption set ON?

  • I am running SS 2005 Ent. Ed. against an intranet SharePoint portal (no SSL used). Should I set 'Force Encryption' ON in Network Configuration from SSCM?

    I am doing a security audit (remediation) for my local shop (D.o.D. client). This was a finding in the Audit check script.

  • From Technet at http://support.microsoft.com/kb/318605

    If the Force Protocol Encryption option is turned on on the server by using the Server Network Utility, communication between all clients and SQL Server is encrypted. Therefore, if a certificate is not installed on the computer that is running SQL Server, or if SQL Server cannot validate the certificate, SQL Server fails to start. The SQL Server error log will have this text:

    2001-08-23 15:12:09.48 server Encryption requested but no valid certificate was found. SQL Server terminating.

    You will need to setup a certificate on the server.

    http://support.microsoft.com/kb/316898

    If it was a bulleted item for your audit, then you will likely need to enable encryption by certificate across the wire.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply