August 3, 2005 at 11:10 pm
How can i Encrypt Database SQL Server 2000 and MSDE2000 ?
August 4, 2005 at 4:38 am
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.
August 4, 2005 at 5:04 am
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?
August 4, 2005 at 5:12 am
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
August 4, 2005 at 5:35 am
can u pls explain this solution
thanx
August 4, 2005 at 10:07 am
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.
August 4, 2005 at 10:12 am
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
August 5, 2005 at 9:20 am
Log on using the same Windows account that SQL Server is running under.
August 5, 2005 at 9:24 am
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.
August 5, 2005 at 10:00 am
You might check out the following article:
Implementing Encrypting File System (EFS) with SQL Server
http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply