Error when I want to deploy SSIS package in vs 2017

Question

0.00/5 (No votes)

See more:

VS2017

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 19-Aug-21 19:55pm

Davood Riazi

Updated 21-Aug-21 4:09am

Add a Solution

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.

2 solutions

Solution 1

See Linked server connection fails with “An error occurred during decryption” | Microsoft Docs[^]

Posted 19-Aug-21 22:12pm

Richard MacCutchan

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Davood Riazi · Accepted Answer · 2021-08-21T04:09:00

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.