Question
You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database.
A recent failure causes the master database to be lost.
You discover that all Microsoft SQL Server Integration Services (SSIS) packages fail to run on the virtual machine.
Which four actions should you perform in sequence to resolve the issue? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
With master lost, the instance no longer knows about SSISDB, so the database must be attached first. The SSIS catalog relies on CLR stored procedures, so the TRUSTWORTHY and CLR properties are turned on next. The database master key is then opened with the password used when the catalog was created, and a copy is encrypted by the service master key so the instance can open it automatically when packages run. Azure Key Vault certificates and Transparent Data Encryption do not relate to this failure.
