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

I need to enable "Force Encryption" for SQL Server 2005, but I don't know which API can do it. I need to operate remote SQL server , so I cannot operate registry directly to do it. Who can help me?

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

|||

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.

|||

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

|||I had a deep look in SMO to find the property with no success.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

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

Regards,

Maciek Sarnowicz