How to Secure the MDF and LDF File with Password

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Security (SS2K8) » How to Secure the MDF and LDF File with...

How to Secure the MDF and LDF File with Password

Rate Topic

Display Mode

Topic Options

Author

Message

tamil.selvanmca

Posted Wednesday, September 05, 2012 9:50 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, April 08, 2013 10:11 PM
Points: 417, Visits: 85

hi,

I've been working on sql server.

I want to protect the mdf file with password.

I develop a windows application with sql server back end, i install into a client system, someone stop the sqlserver service and copy the mdf,ldf and store at diff sql server to know the structure of tables, queries and SPs.

I need a solution to protect the mdf file with password.

Post #1354697

derek.colley

Posted Wednesday, September 05, 2012 9:59 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 8:19 AM
Points: 496, Visits: 584

You need encryption: http://technet.microsoft.com/en-us/library/bb510663.aspx

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??! Crazy

Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Post #1354707

Lynn Pettis

Posted Wednesday, September 05, 2012 10:29 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 3:42 PM
Points: 21,627, Visits: 27,478

If you are looking at TDE, you will need the Enterprise Edition of SQL Server.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1354734

opc.three

Posted Wednesday, September 05, 2012 11:23 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:46 PM
Points: 6,730, Visits: 11,783

tamil.selvanmca (9/5/2012)

TDE will handle the specific question you posted but probably not the underlying intent. There really is no comprehensive way to protect your Intellectual Property (IP) if you're deploying the database to the client site. Anyone who is a local admin on the machine where SQL Server is being hosted can enter the database as a sysadmin if they know to start SQL Server in single-user mode. Encrypting the database with TDE will protect the data at rest, i.e. if someone takes the mdf or a backup of the database to another server they will not be able to access to it without knowledge of the key infrastructure. If you want to protect your IP you'll need to host the database for the solution yourself or move to a hosted solution like SQL Azure.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1354778

knash 79472

Posted Monday, September 10, 2012 12:25 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 01, 2012 1:37 PM
Points: 1, Visits: 24

If you don't want to upgrade to Enterprise to get TDE then take a look at NetLib. They have an encryption tool that will encrypt your SQL database. www.netlib.com/sql-server-encryption.asp

Post #1356949

DBA_Learner

Posted Wednesday, September 12, 2012 7:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:37 PM
Points: 170, Visits: 388

If you do not have enterprise edition, to enable TDE then Secure the folder on the local drive with password.

Post #1357961

« Prev Topic | Next Topic »

Permissions