master key in the database error SSISDB

por | 28 abril, 2023
Please create a master key in the database or open the master key in the session before performing this operation.

Please create a master key in the database or open the master key in the session before performing this operation. (Microsoft SQL Server, Error: 15581)

To fix the error, execute the following queries:

USE [SSISDB]
OPEN master Key decryption by password = 'Password' -- Password used when creating SSISDB
ALTER Master Key ADD encryption by Service Master Key