Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to decrypt a column in a table that has previously been encrypted at application level.

The algorithm is DES at 192 bits and block size = 64.

I have the password but DecryptByPassPhrase doesn't seem to work.

share|improve this question

You need the original key. Most likely the encryption password was used to encrypt the key, not the data. DECRYPTBYPASSPHRASE can be used to decrypt something encrypted by ENCRYPTBYPASSPHRASE. To decrypt something encrypted by ENCRYPTBYKEY, you use DECRYPTBYKEY. The password is used to open the key:


If the encryption key was encrypted by a certificate and the certificate was encrypted by a password (As is often the case) then you obviously need open the certificate using the password. Whoever designed the original encryption scheme should be able to guide you through the proper decryption key hierarchy.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.