How to protect SqlLocalDB database file with a custom password

Question

I developed software using an instance of SqlLocalDb v11.0. The database will be located on the user machine ( .mdffile). I used to use SQL Server CE.

In SQL Server CE, my database is password protected with "Encryption Mode = Engine Default"

Is there a way to protect SqlLocalDB?

I know that there is a way to use named instances, as in the link https://msdn.microsoft.com/en-us/library/hh510202(v=sql.110).aspx

Is there a way to associate a password with a LocalDB file .mdf. So anyone else can’t open it?

Answer 1

If you mean protecting files from the user, I think the answer is “No,” you cannot. user can simply copy files.

LocalDB always works under the security context of users; that is, LocalDB never starts with credentials from the local administrators group. This means that all database files used by the LocalDB instance must be accessible using the user account of user accounts , without considering membership in the local administrators group.

See the "Permissions" section in SQL Server 2012 Express LocalDB for more information.

, .NET Framework TSQL, , TDE ( ) LocalDB.

Answer 2

, ( ), NetLib Encryptionizer. SQL Server TDE, SQL Server, Express LocalDB. . , SQL TDE. SQL TDE () SQL Server . Encryptionizer SQL .

, , DBEncrypt, LocalDB. SQL.

( : NetLib Security).