Unable to access availability database ‘xxxxxxx’ because the database replica is not in the PRIMARY or SECONDARY role.

Error: Cluster Log: Cluster resource ‘xxxxxx’ of type ‘SQL Server Availability Group’ in clustered role ‘xxxx’ failed. Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it.  Check... » read more

0
Read
echiang
Failed to designate the local availability replica of availability group as the primary replica, unable to start role.

Error: Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID ‘xxxxxxxxxxxxx’) online (Error code 5942). The WSFC service may not be running or may not be accessible in its current state, or the WSFC resource may not be in a state that could accept the request. For information about this error code, see “System... » read more

0
Read
echiang