Click here to Skip to main content
15,071,430 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi, When I want to deploy the SSIS package in vs 2017 and I got the below error message. Can someone guide me on how to resolve this issue?

Thanks,

TITLE: SQL Server Integration Services
------------------------------

An error occurred during decryption. (Microsoft SQL Server, Error: 15466)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.2000&EvtSrc=MSSQLServer&EvtID=15466&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


What I have tried:

I tried this query in Microsoft SQL Server 2019 :

USE [SSISDB];
GO
ALTER MASTER KEY force REGENERATE WITH ENCRYPTION BY PASSWORD = 'P@ssw0rd';

OPEN MASTER KEY 
    DECRYPTION BY PASSWORD = 'P@ssw0rd';
ALTER MASTER KEY 
    DROP ENCRYPTION BY SERVICE MASTER KEY;
ALTER MASTER KEY 
    ADD ENCRYPTION BY SERVICE MASTER KEY;
Posted
Updated 21-Aug-21 4:09am
Comments
Patrice T 20-Aug-21 3:42am
   
What says the link in error message ?
Richard MacCutchan 20-Aug-21 3:48am
   
Try it.
Patrice T 20-Aug-21 3:52am
   
me ?
Richard MacCutchan 20-Aug-21 4:09am
   
Yes, it's a bad link.
Davood Riazi 20-Aug-21 3:52am
   
An error occurred during decryption. (Microsoft SQL Server, Error: 15466)

Davood Riazi 20-Aug-21 4:01am
   
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 4:09am
   
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.

I solved the problem :

fist I renamed the SSIDB database to SSIDB2 as below script :

USE SSISDB
GO 

ALTER DATABASE SSISDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER DATABASE SSISDB MODIFY NAME = SSISDB2
GO

ALTER DATABASE SSISDB2 SET MULTI_USER
GO


and after that, I created a new SSIDB database as following link that describes how to create the SSIS Catalog database (SSISDB) 


https://www.sqlshack.com/introduction-to-the-ssis-catalog-database-ssisdb/[^]

and then I deployed the package in VS 2017 successfully.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900