Click here to Skip to main content
15,887,683 members

Comments by Davood Riazi (Top 8 by date)

Davood Riazi 20-Aug-21 4:09am View    
I run this script in the SQL server to drop the master key :

USE SSISDB
GO

DROP MASTER KEY;
GO

But when I run the above script, It shows an error message as below :

Msg 15580, Level 16, State 1, Line 4
Cannot drop master key because certificate 'MS_Cert_Proj_1' is encrypted by it.
Davood Riazi 20-Aug-21 4:01am View    
I want to drop the master key and create a new master key on the SSISDB database in the SQL server.
Davood Riazi 20-Aug-21 3:57am View    
Deleted
Try what?
Davood Riazi 20-Aug-21 3:55am View    
Deleted
what do you mean?
Davood Riazi 20-Aug-21 3:52am View    
An error occurred during decryption. (Microsoft SQL Server, Error: 15466)