How to enable "Force Encryption" for SQL Server 2005?

How to enable "Force Encryption" for SQL Server 2005?

• Seppe001

  Sung, thanks your reply

  I want to do step 3 by SMO or other API.

  1. Open SQL Server Configure Manager

  2. Right click "SQL Server 2005 Network Configuration", select "Properties".

  3. Click tab "Flags", set "Force Encryption" to Yes.

  
  

• Dovikel

  You need to set SqlConnecitonInfo.EncryptConnection property to true before creating a connection to the server.

  Regards,

  Maciek Sarnowicz

  
  

• Sam Vella

  I don’t know if SMO (or any other API) provides such functionality, I would recommend posting your question in the following forums:

  · SQL Server Tools general (http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=84&SiteID=1)

  · SQL Server SMO/DMO (http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=88&SiteID=1)

  -Raul Garcia

  SDE/T

  SQL Server Engine

  
  
  

• wencey

  I had a deep look in SMO to find the property with no success.
  
  HTH, Jens K. Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---
  

• isurge

  Hi Jimmy,

  I'm not sure what you mean by "Force Encryption". Are you referring to "Force Protocol Encryption" in SSL If so, you can find further details here:

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

  Please let me know if this helps,

  Sung

  
  
  
• How to enable "Force Encryption" for SQL Server 2005?