Decrypt issue - Msg 15581, Level 16, State 3, Line ...

• nithiyanandam-447806

  Ten Centuries

  Points: 1197

  More actions

  June 8, 2010 at 2:58 am

  #219750

  The decryption is not working. This is a dev db (sql 2005), and it was restored from the production db backup. After restoring, we tried to run the stored procedure which contains the decryption logic.

  The procedure having the following code...

  open symmetric key enckey decryption by certificate DS_Encryptcert

  the above code through the following error

  Msg 15581, Level 16, State 3, Line1

  Please create a master key in the database or open the master key in the session before performing this operation.

  Pls can any help on this...

  Thanks in advance.

  Nithi

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  June 8, 2010 at 3:13 am

  #1177355

  Hmmm, I've read about this problem before. I think the code you want is: -

  OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'

  ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY

  CLOSE MASTER KEY

  I've tried looking for the blog I read this on, but can't find it.

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---