SEO

#1 (**permalink**) 05-05-2008, 05:51 AM

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?

#2 (**permalink**) 05-05-2008, 05:51 AM

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/...24/415079.aspx

bye,
Helmut

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Force protocol encryption on hosted database