View Single Post

   
  #1 (permalink)  
Old 05-05-2008, 05:51 AM
jbot
 
Posts: n/a
Default Force protocol encryption on hosted database

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?
Reply With Quote