I have an sql server 2005 database in a shared host environment. I
have an access database that links to a few of the tables over odbc.
I want to set the server to require that all data be encrypted.
I found this post that seemed to apply
Using Encryption Without Validation
http://msdn.microsoft.com/en-us/library/ms131691.aspx
It looks like I need to set Trust Server Certificate and Force
Protocol Encryption.
The shared environment allows me to execute commands against the
database. I am wondering if there is any way to set the database to
force encryption from this command line?