Encrypt Database

Question

Encrypt Database

nitin jain-250047

SSC-Addicted

Points: 401
More actions
August 3, 2005 at 11:10 pm

#186876

How can i Encrypt Database SQL Server 2000 and MSDE2000 ?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 1

You can't do it directly but should be able to encrypt information comming in from a web server or application fairly simply though.

I know SQL 2000 has some inbuilt encryption functionality but to be honest most people know how to get round that

One issue I should point out is that the performance hit in and again out of the database will need to be included when considering how fast the system is working, depending on how you do the encryption/decryption it could significantly add to the time.

nitin jain-250047 SSC-Addicted Points: 401 More actions · Answer 2

thanx sir but i have this problem-

"I plan to use an MSDE (or Sql Server Express) database in my single-user

application. My problem is that the mdf file will be accessible (at least

readonly) to anyone using the application. How can I be sure that the user

cann't copy the mdf file and attach it to another server and view all the

information he wants to?"

what can i do for this?

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 3

ah, so you want to encrypt the actual physical files rather than the data.

That's already possible in the OS, just login as the account that SQL is running under and encrypt the folders using that account. That way it can always access them but no-one else can.

Mike

PS. I think/hope I got this right (2003 server onwards) if not please feel free to correct me

nitin jain-250047 SSC-Addicted Points: 401 More actions · Answer 4

nitin jain-250047

SSC-Addicted

Points: 401

August 4, 2005 at 5:35 am

#579505

can u pls explain this solution

thanx

Steve J. Larson Right there with Babe Points: 790 More actions · Answer 5

I am very curious about this as well. It comes at a perfect time since I need to develop a VERY secure database and don't want anyone simply getting access to the folder were it resides and stealing it.

More information on the encryption would help me immensely.

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 6

I'm just about to head off home for the evening but if no-one has filled in the process by tomorrow morning i'll post it then.

Mike

Steve Walcher Old Hand Points: 327 More actions · Answer 7

Log on using the same Windows account that SQL Server is running under.

To encrypt a file or folder

Open Windows Explorer.
Right-click the file or folder that you want to encrypt, and then click Properties.
On the General tab, click Advanced.
Select the Encrypt contents to secure data check box.

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 8

Oops, sorry I forgot to check back to see if anyone had posted a reply about this one.

Steve's right in what he's saying but remember to do it as the login that is running the SQL service or you might have problems accessing it.

Steve Walcher Old Hand Points: 327 More actions · Answer 9

You might check out the following article:

Implementing Encrypting File System (EFS) with SQL Server

http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp