Hi all,

Today I received a petition from a customer, they want to encrypt the information from a database because they want to set LOPD rules. In this platform we have two front end with SharePoint 2010 SP2 and a SQL 2008R2 Enterprise.

I started to search some information about encryption in SharePoint 2010, I have seen TDE, some developments like http://cipherpoint.com/data-security/sharepoint-security/ and some Powershelling.

But I need to know the experience of someone that has already set encryption in SharePoint, because I already have some doubts about TDE, for example, you encypt the databases, but when you Access to the information trought SharePoint it's still there, isn't it? How Works Powershell in this scenario? It is necessary to have a scheduled task to encrypt all the files? And how it Works a custom development?

Feel free to ask me any doubts

Thanks in advance,

TDE encrypts the data using a key that's stored in the SQL instance... any time you access the database, it's available to work with as if it were unencrypted.

the only time TDE impacts your ability to use the file/data, is if you were trying to read the MDF files by hand (binary or hex or whatever), or if you tried to attach it to your own instance of SQL (without the key)... in these cases, the data is encrypted and inaccessible.

Thanks Scott, very useful information :), If anyone else could helpe me some piece of information or recomendation about encryption, would be appreciated

• Edited by albandrod 1 hour 5 minutes ago