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 |
|
jns
Starting Member
19 Posts |
 Posted - 2003-11-15 : 14:31:27
|
| Is it possible to encrypt/decrypt TripleDES encryption from within T-SQL? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-15 : 18:12:21
|
| This product provides encryption for SQL Server data:http://www.activecrypt.com/It does not do Triple DES unless you purchase a redistribution license, but it does support other encryption algorithms that are at least as secure. |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-11-15 : 20:52:38
|
| From a performance perspective I think you would be much better off doing your encryption outside of SQL Server. In a middle tier..NET for example makes doing encryption pretty painless.Damian |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-11-16 : 21:40:02
|
| I agree with Damian. Also, there are more secure and efficient encryption algorithms than DES3 available today, such as the AES standard - Rijndael. One otion might be to consider a product such as Xceedsoft (http://www.xceedsoft.com/products/Encrypt/) which can be exposed as a udf via sp_oa methods. However, to answer your question, it is possible to perform the DES3 algorithm in T-SQL. Here is a link illustrating the DES algorithm: http://www.aci.net/kalliste/des.htm |
|
|
|
|
|
|
Triple DES encryption within T-SQL