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 |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2007-05-01 : 21:55:58
|
| Hello everyone,Let me first explain what I want to do.We have a IBM DB2 database where one of the column in our table is encrypted. This encrypted column is encrypted using RC2 block cipher algorithm. And they key DB2 uses is MD2 digest of a particular user password. Now, data from DB2 database gets transferred into our SQL Server 2005 database with that encrypted data in it. What I want to do is to create a view that can allow use to see decrypted data for that particular encrypted data. Now as far as I know, SQL Server 2005 does support encryption and decryption functionality and it does support RC2 encryption-decryption with a symmetric key. But what I don't know is how the key gets generated in SQL Server 2005. Since, I need to provide same key that gets used in DB2 to SQL Server 2005, I don't know how to do that. In short, we know that password based on which the key gets generated on DB2 with MD2 digest algorithm built in it. But do we have functionality to manually generate key with the MD2 digest algorithm with same password in SQL Server 2005?If not, do we have a work around for that? Like, I generate a MD2 digest of the password with some tool and then store it in SQL server somewhere so that can be used as symmetric key?Thanks,Ujjaval |
|
|
|
|
|
Custom Encryption key in SQL Server database