如何保护sqlexpress mdf文件 [英] How to protect sqlexpress mdf file

问题描述

大家好。



我用c＃和SQL express mdf文件开发了一个windows base应用程序作为数据库;

我不喜欢我希望任何人都可以访问我的数据库（表格）



什么是保护mdf文件数据库的最佳方法，所以没有人访问它？

是否可以设置用户并传递从每个系统和服务器连接到数据库所需的内容？



请帮助我

解决方案

根据您使用的SQL版本，您可以应用透明数据加密（2008年推出），这意味着一旦您提供了加密密钥，所有操作都会继续，就像数据库未加密一样： http://technet.microsoft.com/en-us/library/bb934049.aspx [<一个href =http://technet.microsoft.com/en-us/library/bb934049.aspxtarget =_ blanktitle =新窗口> ^ ]



请注意几点但是：

1）数据离开SQL服务器后不再加密：所以监控网络的任何人都可以读取它。

2）备份数据未加密 - 所以你需要自己确保。备份 文件 是，但是通过SELECT命令创建的任何数据都不是。所以SELECT * INTO NewTableName不会自动加密新表，除非它也在加密数据库中。

3）如果你丢失加密密钥，你将无法恢复数据

Hi every one

I have developed a windows base application by c# and SQL express mdf file as database;
I don't want anyone to access my database(tables)

what is the best way to protect the mdf file database so nobody access that?
is it possible to set user and pass that needed for connecting to database from every system and server?

Please help me

解决方案

Depending on the version of SQL you are using, you can apply Transparent Data Encryption (introduced at 2008) which means that once you have provided the encryption key all operations continue as if the DB was not encrypted: http://technet.microsoft.com/en-us/library/bb934049.aspx[^]

Be aware of a few things though:
1) The data is no longer encrypted once it leaves SQL server: so anyone monitoring the network can read it.
2) Backup data is not encrypted - so you need to secure that yourself. Backup files are, but any data created via SELECT commands is not. So "SELECT * INTO NewTableName" will not automatically encrypt the new table, unless it is also in an encrypted database.
3) If you lose your encryption key, you will not be able to recover the data.

这篇关于如何保护sqlexpress mdf文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！