SQL 2005 Encryption with off-the-shelf software
- From: brimoore@xxxxxxxxxxx
- Date: 3 Jan 2007 07:21:54 -0800
I've been reading up on SQL Server 2005 encryption options, and it
seems that when retrieving encrypted data you must use either a key or
a certificate in your query to decrypt the data.
What if I am using a commercial, off-the-shelf product that utilizes a
SQL Server backend? Since I would not be designing the queries (they
would be "built in" to the app) is it possible to use SQL Server
Encryption?
My guess is that the 3rd party app would have to have native support
for SQL Server Encryption, probably in the form of a configuration
screen where one could enter a key or certificate information. But I
am new to this, and perhaps there is another way...
Any insights would be appreciated.
.
- Follow-Ups:
- Re: SQL 2005 Encryption with off-the-shelf software
- From: Plamen Ratchev
- Re: SQL 2005 Encryption with off-the-shelf software
- Prev by Date: Re: Using VSS to manage stored procedures with SSMS
- Next by Date: LocalSystem and the sysadmin role
- Previous by thread: Re: Using VSS to manage stored procedures with SSMS
- Next by thread: Re: SQL 2005 Encryption with off-the-shelf software
- Index(es):
Relevant Pages
|
|
