CODEWITHSUNDEEP
encryptionfilestream
user3396360
user3396360

Reputation: 51

Best way to encrypt FILESTREAM data?

I was wondering what is the way for the FILESTREAM data encryption (for example .docx files) in SQL Server? Is it Microsoft EFS or there is another solution?

Thanks in advance

Upvotes: 5

Views: 2330

Answers (2)

Neil Weicher
Neil Weicher

Reputation: 2502

"Is it Microsoft EFS or there is another solution?"

Since you asked about other solutions as well, there are two third party products that offer alternatives to TDE including FileStream encryption. They both work with all versions and editions of SQL Server. One is NetLib Encryptionizer for SQL Server and the other is DBDefence. Although they both work differently. Encryptionizer sits between SQL Server and the OS, while DBDefence injects code into the running SQL process using the (now defunct) Detours SDK. (Disclaimer: I am with NetLib Security).

Upvotes: 0

jmcilhinney
jmcilhinney

Reputation: 54457

As far as I'm aware, there's no encryption built into the FILESTREAM feature. I would generally expect the application fronting the database to handle any encryption of the data before sending it to the database and decrypting after retrieval.

Upvotes: 2

Related Questions