December 16, 2009 at 12:09 pm
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.
December 21, 2009 at 4:16 pm
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