After recovering and re-importing a backup of a SQL Server 2019 instance none of my SSIS packages will deploy from Visual Studio.
Whenever I try and deploy I get the error
===================================
An error occurred during decryption. (.Net SqlClient Data Provider)
------------------------------
Server Name: SSRS02\HEALTHAWARE
Error Number: 15466
Severity: 16
State: 9
Line Number: 1
I have tried to reimport the backup of the encryption key that I have through the Report Server Configuration Manager, and have run the following and have seen it succeed, so I am assuming that my master key is correct, and I have the correct decryption password for the master key.
OPEN Master KEY
DECRYPTION BY PASSWORD = 'xxxxxxxxxxx';
ALTER Master KEY
DROP ENCRYPTION BY SERVICE MASTER KEY;
ALTER Master KEY
ADD ENCRYPTION BY SERVICE MASTER KEY;
CLOSE MASTER KEY;
GO
I cannot however figure out what I need to do in order to get the SSIS Packages to deploy from Visual Studio