Sunday, February 19, 2012

EFS,SQL Server 2005 and Windows 2003

Has anyone used the Encrypting File System (EFS) capabilities of the OS to
encrypt the sql server 2005 data files? I am looking to do this but cannot
find any examples/instructions. Thanks.A little old but a good starting point nonetheless:
http://msdn2.microsoft.com/en-us/library/aa302434.aspx
Just remember to be consistent about what you use to perform the encryption
and the SQL Server service account both during setup and when you change
passwords. Getting locked out of your own DB sounds funny but really isn't.
joe.
"SQLUSER07" <SQLUSER07@.discussions.microsoft.com> wrote in message
news:F669E408-E3FC-41F6-8616-E95E5DA7A108@.microsoft.com...
> Has anyone used the Encrypting File System (EFS) capabilities of the OS to
> encrypt the sql server 2005 data files? I am looking to do this but cannot
> find any examples/instructions. Thanks.

No comments:

Post a Comment