We have 2 nodes configured for AlwaysOn.
it works on the primary replica.. but when I failover to secondary replica it throws an error that " please create master key"
but when I run below, it works fine
open master key decryption by password = 'NNN' --'Password used when creating SSISDB'
Alter Master Key Add encryption by Service Master Key
Am I missing anything from the configuration side?
My goal is not to the run the above query manually every time it fails over.
Any help is appreciated. Thanks.