I get the following error message when trying to create an "environment" within a folder in the SSIS Catalog:
Msg 15581, Level 16, State 7, Line 17
Please create a master key in the database or open the master key in the session before performing this operation.
When I try to OPEN MASTER KEY DECRYPTION BY PASSWORD = N'passwordIdonthavegoeshere', I get the error that tells me that the key is not encrypted by that decryptor. So that's what I'm talking about. There are existing environments on this server, and I've created a new folder that I want to have as the one standard folder for all packages to "reference". Ideally, a query that can at least identify what will be lost when I try ALTER MASTER KEY FORCE REGENERATE ... would tell me which info will be lost so I can proactively get that info ahead of time and be able to put it all back after the forced regeneration.