Error after migration and upgrade of SSISDB to new SQL instance

Question

I have SSISDB on SQL server 2017. My new environment is SQL Server 2022. I followed the steps mentioned here - https://learn.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver16 and then did the 'Database Upgrade' of SSIS DB.

Ran exec catalog.check_schema_version 0 to verify and no error returned. But when i try to execute SSIS package, i get this error -

An error occurred during decryption. (Framework Microsoft SqlClient Data Provider)

Please advise

Regards

Answer 1

Hi @Digvijay Avachat,

Encrypt the SSISDB to see if it is helpful.

open master key decryption by password = 'xxxxx' –‘Password used when creating SSISDB’  
Alter Master Key Add encryption by Service Master Key

Please also check ProtectionLevel have you selected for the package.

Check:
https://learn.microsoft.com/en-us/sql/integration-services/security/access-control-for-sensitive-data-in-packages?view=sql-server-ver15#protection-levels

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.