Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 User Database Protection

Author  Topic 

Roham
Starting Member

5 Posts

Posted - 2010-09-28 : 16:02:01
How to protect SQL Server data (file.MDF and .LDF) from being taken opened in another computer that it is copied?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-28 : 16:08:08
Restrict who has access to the server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Roham
Starting Member

5 Posts

Posted - 2010-09-29 : 11:59:08
I have an application that use the express edition of Sql server 2008, if want do not allow user open MDF files on another computer that copied the MDF files.

quote:
Originally posted by tkizer

Restrict who has access to the server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-29 : 12:56:02
Why does the user have access to the database files in the first place?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Roham
Starting Member

5 Posts

Posted - 2010-09-29 : 16:02:26
because the application be installed on the client machine (user machine)
quote:
Originally posted by Roham

I have an application that use the express edition of Sql server 2008, if want do not allow user open MDF files on another computer that copied the MDF files.

quote:
Originally posted by tkizer

Restrict who has access to the server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-29 : 16:25:22
There isn't a way to lock it down if the database server is the client machine.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Roham
Starting Member

5 Posts

Posted - 2010-09-29 : 18:29:50
probably there is a solution from micro soft, Do you think, can i use the MS ACCESS to solve the problem or use a disk protection software same as (TrueCrypt), if disk protection software can be embedded to installation program.

quote:
Originally posted by Roham

because the application be installed on the client machine (user machine)
quote:
Originally posted by Roham

I have an application that use the express edition of Sql server 2008, if want do not allow user open MDF files on another computer that copied the MDF files.

quote:
Originally posted by tkizer

Restrict who has access to the server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog





Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-29 : 18:31:30
Encrypt your data if this is a concern.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -