Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can you encrypt an enitre SQL 2000 database?
- Thread starter mb224
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Yes and no.
No within SQL there is no way to encrypt the entire database.
Yes if you wrote your app to encrypt every value in every field, then yes, but you would have extremly high overhead.
A better solution would be proper patch managment, good solid firewall/acl setup to protect from the outside, and a nice long extra strong password for the SA account and the NT account that the Service Runs under.
Denny
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
(My very old site)
No within SQL there is no way to encrypt the entire database.
Yes if you wrote your app to encrypt every value in every field, then yes, but you would have extremly high overhead.
A better solution would be proper patch managment, good solid firewall/acl setup to protect from the outside, and a nice long extra strong password for the SA account and the NT account that the Service Runs under.
Denny
--Anything is possible. All it takes is a little research. (Me)
(My very old site)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
