SQL 2005 Decryption RC4 values from another system.

[hugostyles]

Does anyone know if this is possible.

1. Credit card number is encrypted RC4 standard on iSeries box.
2. The encrypted data is sent to SQL 2005 in csv format with the password used for the encryption.

e.g.

Encrypted Value | Password
˜ž†?âD¯k“(‘ˆ›´ | MyPassword
šœ? {¶ª“ᛊ›¯ | MyPassword

3. Can we decript colum1 (Encrypted Value) using t-sql on SQL 2005 to reveal the credit card number?

All my research suggests that you can only decrypt what was encrypted on a SQL Server. Is this correct?

 

[starsky51]

Assuming the Password column contains the key that was used to encrypt the card number, you should be able to use the stored procedures laid out here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76258

 

[hugostyles]

Thanks for the response. I think I tried that and it basically encrypted my already encrypted credit card. e.g.

˜ž†?âD¯k"('ˆ›´ >>> 234asf9!"$"£$

and then back to ˜ž†?âD¯k"('ˆ›´

That link you sent work well for encryption/decryption - on the same SQL Server or between SQL Servers. I'll keep hunting.