Force protocol encryption on hosted database

[jbot]

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?

[Helmut Woess]

Re: Force protocol encryption on hosted database

Am Fri, 2 May 2008 09:50:37 -0700 (PDT) schrieb jbot:
...

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

Think you mix something up. This is encryption for network traffic, not for
your data! Take a look at this:

http://blogs.technet.com/keithcombs/archive/2005/11/24/415079.aspx

bye,
Helmut