SQL 2005 Encryption error

[jeffwest2]

I am trying to do some testing of data encryption on a local instance of SQL 2005.

I have created a database which has 1 table, when running
<code>create master key encryption by password = '*************';</code> I get the following error,

An error occurred during decryption.

Does anyone know what the heck I can do to resolve this.

Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about seeing tomorrow — there's one thing you never — ever, put in a trap. … Me.

 

[TomKane]

Do you have encryption already in place? It seems odd the SQL Server would be complaining about decryption when you're trying out encryption for what I'm assuming is the first time.

Is there anything in your error log around the time of attempting the encryption that give us a bit more information?