This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 63%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETE%3C/text%3E%3C/svg%3E)
I have had a problem with the SQL server and I was able to recover the MDF/LDF and the BAK. The user DBs work but the SSISDB gives me an error. I have attached the DBs and it fails, I have restored the backup and it fails. I don't have the master key.
Error: Failed to locate the project named xxxxxxxx.:An error occurred during decryption.
Can you help me?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
The SSISDB is an encrypted database. If you did not backup or have access to the master key, that data is lost. You will need to use the default SSIS DB and redeploy your SSIS packages.
Hi @Thor El Poderoso ,
We should backup the master key and SSISDB database and then restore them.
Please refer to the following steps:
SSIS Catalog - Backup and Restore
moving-the-ssisdb-catalog-on-a-new-sql-server-instance
If you do not have the master key, try to regenerate it.
alter-master-key-transact-sql
DON'T try it on PROD server until you verify the above on a test server / database.
Regards，
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 37%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Hi Zoe,
I am facing the same error.
I have SSISDB on SQL server 2017. My new environment is SQL Server 2022. I followed the 4 steps you mentioned above 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)
Regards