Hi Everyone,
I wanted to see if anyone has came across below SSISDB error in AG environment.
I did implement SSIS package on primary SQL server- 2019 using SSIS catalog. Added SSISDB to part of AG and using listener to connect. Every thing went well as expected.
Below error is coming when I did fail over and trying to run SSIS package from the second node. Can anyone let me know what steps needs to be taken on secondary node since this is new for SSIDB?
Error Number: 15581 Please create a master key in the database or open the master key in the session before performing this operation. (.Net SqlClient Data Provider)
Thank you and be safe and healthy.