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
 Transparent Data Encryption

Author  Topic 

EJLindsay
Starting Member

1 Post

Posted - 2009-06-26 : 12:46:47
I put together a simple TDE example. I am confused about who can see the data.


I checked to make sure TDE had been implemented using:

-- Check whether the encryption_state is changed to 3. It should be.
SELECT DB_NAME(database_id) AS DatabaseName, * FROM sys.dm_database_encryption_keys


Once I setup TDE I was still able to see the data from my own machine. This was not suprising. I then logged onto a remote machine and I was still able to see the data. This was surprising.

What am i missing?

Jay

vishal.todkar
Starting Member

20 Posts

Posted - 2009-07-14 : 04:09:11
Hi I need some information on cell 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 sql server is using TDE or cell level encryption and this server is also encrypted with PointeSec or NTFS or other 3rd party disk encryptions, will this kind of enviornemnt supported by SQL SERVER ?
Go to Top of Page
   

- Advertisement -