Symptoms

SQL Availability Groups failover intergration
 

Diagnoses

Utilizing SQL availability groups. In SQL availability groups with a witness server to facilitate fail overs. The principal is that when patching needs to be performed the fail over will allow for minimal disruptions.

The problem is that when the fail over occurs K2 gives errors relating to the SCSSOKey as follows.
"Please create a master key in the database or open the master key in the session before performing this operation.
The key 'SCSSOKey' is not open. Please open the key before using it."

For the time being running the script that drops and recreates the key, or opens and re encrypts the key is performed as a manual step.

The request is for some mechanism to remove the manual step from the Availability Group fail over.


 

Resolution


Please review the following Doc

http://help.k2.com/kb001572