12 March 2013

TDE Error solution


·         It could be trivial question.I have trouble dropping master key. when i execute the following query..
open
master key decryption by password = 'pass1234$'
alter
master key drop encryption by password = 'pass1234$'
close
master key
drop
master key
go
I get the following result..
Msg 15558, Level 16, State 1, Line 3
Cannot drop encryption by password '********'.
Msg 15580, Level 16, State 1, Line 5
Cannot drop master key because certificate 'BackofficeServiceAccount' is encrypted by it.
But 'BackofficeServiceAccount' was already dropped.
Can any one help me how to drop master key?

Solution:

·         I realized the script was creating login and certificate with the same name.
Dropping the certificate first, helped dropping the master key...

No comments:

Post a Comment