Roland Mayr


Is there any way to encrypt the sql server mdf and ldf data files in SQL Server 2005 without using EFS or creating an additional system user Only one application which has the password embedded (i know this is a security risk) should be able to connect to the database and access the mdf and ldf files.

Greetings
Roland Mayr



Re: SQL data file encryption

Jens K. Suessmeyer


No. you will have to secure your data files on the OS level for unauthorized access.


HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---