Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Encrypting LOBs / Filestream / Filetable in SQL Server 2012

Answered Encrypting LOBs / Filestream / Filetable in SQL Server 2012

  • Thursday, February 07, 2013 4:01 PM
     
     
    Sign In to Vote
    1

    The application users upload their documents(.pdf,.jpg,.docx etc) using asp .Net as front end. I am planning to store the file as FileTable using SQL Server 2012. Along with that I need to encrypt the file as well. No one other that the file uploader should have access to the file. Not even the DBA or the windows administrator should be able to open and see the information stored in the file.


    --------------------------------------------------------------------------------

    Thanks & Regards, sathya

     

All Replies

  • Thursday, February 07, 2013 4:11 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    You can use NTFS encryption using the service account of the database engine.

    David Dye My Blog