How to protact mdf database file from xcopy.

Question

1.00/5 (1 vote)

See more:

Once I create SQL database mdf file in root database user in virtual VeraCrypt Volume Local Disk M:\
Thats actuly accessaible from PC- father administrator or User just in mount Volume.and Not accessaible SQL connection to database in Dismounted.even SQLExpress Services is Runing.
because the instance root directory is on local OS C:\
so mdf database file is NOT prtacted from XCopy PC- user and admin.
so if the admin is the owner of software and database I can make access deny proviladge of user from volume or file or folder security.
but that can be easly proken to the password for father admin from the user he has password of his VeraCrypt OS Volume by using hiering boot.
Even VeraCrypt Encrypt of the entier OS Volume.
so admin proviladge .. gone.
and SQL manager 'sa' Password is Not important because XCopy of mdf File moved to another Server.
now SQL.mdf file is NOT protacted at all. just from user and admin.
- so how can I protact SQL mdf file. 3rd party.
Not by TDE Transparent db Level because only enterprise Edition have this Feature with Cost.
and NOT by SQL Express 2016 adv.
Allows encrypted because that is only for db Colume Level.
I Need any way to give me Stong Security Protaction of database for free.3rd Party level.
and NOT by DBDefence or auther.
Thank you..

What I have tried:

1- VeraCrypt for
File Encryption and OS Encryption.
2- Security admin Proviladge.
3- DBDefence.
4- Allowes Encrypted sql Express Adv 2016.

Posted 19-Aug-17 23:41pm

Member 12834458

Updated 20-Aug-17 4:05am

Add a Solution

Comments

[no name] 20-Aug-17 5:56am

I'd suggest that question is best posted here: VeraCrypt - Discussions[^]

Patrice T 20-Aug-17 5:56am

Try to use spell checker.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2017-08-20T03:58:00

Your post made little to no sense at all but from what I can gather, you're trying to prevent the SQL database file, .MDF, from being copied by anyone on the machine.

Simple. You can't prevent it at all.

If the user of your application needs to access the database and you're using a user-instance of SQL Express, the user MUST have read/write access to the MDF file.

Administrators on the machine will always have read/write access just about every folder on the machine.

If you want to protect the database file from being copied, you have no choice but to put it behind a full SQL Server, not the Express edition.

RickZeeland · Answer 2 · 2017-08-20T04:05:00

Solution 2

Here is a good overview of encryption options: SQL Server Encryption Options | Microsoft SQL Server content from SQL Server Pro[^]

Posted 20-Aug-17 4:05am

RickZeeland