Upgrade SQL SSISDB
When upgrade SSISDB, a few steps need to be considered when moving the SSISDB to a higher version on a new SQL instance.
1; Backup currently database master key
BACKUP MASTER KEY TO FILE = 'file location/name' ENCRYPTION BY PASSWORD = 'your password for the backup key file' If you forgot the current password for the master key, you can reset the password via backup the master key (if not already have one) and then restore it with a new password
Posted by John Liu Tuesday, July 19, 2022