I recently encountered an error after a planned failover of an AG to the secondary node after patching it. I am on SQL 2016 enterprise. we have the reportserver in the AG, but after failover I got the below error.
This is a 2 node AG, both participating in scale-out deployment. on the node that was rebooted the scale-out tab in config manager does not show any of the nodes present, but the other node shows both nodes as joined.
As soon as I restore the encryption key to the primary node the issue goes away... Does anyone know you would need to restore the encryption key after a failover? I can understand after a migration or something, not i would not think it should be needed after a failover.