Sample Header Ad - 728x90

SSIS cannot deploy package to SQL server - An error occurred during decryption 15466

0 votes
1 answer
1973 views
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
Asked by Xenology (101 rep)
Jan 21, 2021, 03:15 AM
Last activity: Dec 27, 2024, 11:05 PM