Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-09-22 : 06:39:53
|
| Hi ,I would like to know whether SQL server 2000 Enterprise edition supports 3DES encryption and that is it possible at database field level . I guess , SQL server by default has SSL encryption built -in if it is enabled . I am really not sure whether encrytion is supported at field level with 3DES . Is 3DES more secured than SSL ? and if that's really possible will it add any overheads or would require database structure to be changed to store hex. values ? Any thoughts on this ?? Would like to have any information in this regard . Would be much helpful to me .Thank you . |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-09-22 : 07:04:03
|
| SQL Server's internal encryption is not strong, it's one way and it's undocumented. So don't go there.You can encrypt data using external components, or an extended stored proc (just click refresh here 5 times and you will see a banner for it) but there WILL be a significant overhead.Unless you REALLY need to encrypt something you are much better off with a good security policy. If you do a forum search you will find a hundred threads on this topic.Damian |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2003-09-23 : 00:10:56
|
| Thanks Damian ,Yes I agree , Probably it would be a good idea to look at the third party tools . Need to explore some of them to get an overview . |
|
|
|
|
|
|
Database Field level encryption.