Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Secure the MDF and LDF File with Password Expand / Collapse
Author
Message
Posted Wednesday, September 5, 2012 9:50 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, June 22, 2014 9:45 PM
Points: 422, Visits: 92
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
Posted Wednesday, September 5, 2012 9:59 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 22, 2013 9:13 AM
Points: 496, Visits: 601
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??!

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
Posted Wednesday, September 5, 2012 10:29 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:42 AM
Points: 20,799, Visits: 32,717
If you are looking at TDE, you will need the Enterprise Edition of SQL Server.



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
Posted Wednesday, September 5, 2012 11:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 7,135, Visits: 12,745
tamil.selvanmca (9/5/2012)
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.

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
Post #1354778
Posted Monday, September 10, 2012 12:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 1, 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
Posted Wednesday, September 12, 2012 7:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 12:57 PM
Points: 182, Visits: 423
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 »

Add to briefcase

Permissions Expand / Collapse