Click here to Skip to main content
15,943,148 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)


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.
 
Share this answer
 

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