Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 TDE, column level Encryption support.

Author  Topic 

vishal.todkar
Starting Member

20 Posts

Posted - 2009-07-14 : 04:12:40
Hi I need some information on column level and full database encryption using 2005 and/or 2008.
Does TDE or cell level encryption works fine with PointeSec or NTFS or other 3rd party disk encryptions. i mean if custmer site sql server is using TDE or cell level encryption and also this server is encrypted with PointeSec or NTFS or other 3rd party disk encryptions, will this kind of enviornemnt supported by SQL SERVER ?

or is it like TDE or cell level encryption does not work if SQL server machine is encrypted/decrypted by NTFS or other 3rd party encryption software? Thanks in advance :)

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-14 : 05:52:58
Hi

I think it’s available in SQL SERVER 2008

Refer this link
http://msdn.microsoft.com/en-us/library/cc278098.aspx


-------------------------
R..
Go to Top of Page

vishal.todkar
Starting Member

20 Posts

Posted - 2009-07-15 : 04:01:59
The given article talks about TDE, Cell level encryption and other encryption features.
There is a note which says TDE and EFS both can be used together. only performance is a drwaback.

What I wanted actually is,

Suppose our Customer is already using PointSec disk Encryption or NTFS Encryption feature to protect their SQL server machine. Now our company will deploy cell level or TDE at that customer site to protect SQL server data. Now my doubt is, can our TDE or cell level SQL server encryption feature will work under the environment where PointSec disk encryption, NTFS or any other 3rd party Encryption is already running on SQL Server machine?

I appreciate your response and thanks very much.
Go to Top of Page

UrvashiSaxena
Starting Member

1 Post

Posted - 2014-11-29 : 11:43:50
Vishal, probably not because how they encrypted will likely be different. If you can find the algorithm, you can hire a data protection vendor (IRI) to develop and deliver the field-level decryption routine we needed. And FWIW, their FieldShield (www.iri.com/products/fieldshield) data masking tool is cross-DB and multi-function, running in Eclipse.
Go to Top of Page
   

- Advertisement -