Force Protocol Encryption on SQL Server

Force Protocol Encryption on SQL Server

Post by bill » Thu, 01 Sep 2005 22:47:23


Let me phrase my question this way -

If Force Protocol Encryption is enabled in the Server Network Utility, can
an ADP still access the SQL Server?

Does the client need a certificate installed?

Are there any other considerations?

Thanks!
Bill
 
 
 

Force Protocol Encryption on SQL Server

Post by Sylvain La » Fri, 02 Sep 2005 15:02:53

Never tried it but if you set the property Use Encryption for Data to true
in the OLEDB connection, it should work with ADP in my opinion. (Look under
the All tab in the connection window.)

For more information:
http://www.yqcomputer.com/

http://www.yqcomputer.com/ ;en-us;276553

http://www.yqcomputer.com/

Finally, you should post in the m.p.sqlserver.security newsgroup.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://www.yqcomputer.com/