SQL Server ERROR 35222 When Removing a Replica from an Availability Group
- Microsoft SQL Server 2017
When removing a node from a SQL Server 2017 availability group Vhost, the secondary replica is not removed from the availability group on the primary replica.
This is a known issue with SQL Server 2017 availability groups that are not running Cumulative Update 1 or higher. This error only occurs when the cluster type is set to either “NONE” or “EXTERNAL”. The following error is logged to the DH2i Event Log when attempting to remove a node from an existing availability group Vhost.
Log Name: DH2i Source: DxEngine Date: Event ID: 1001 Task Category: None Level: Error Computer: Description: Caught exception: System.Data.SqlClient.SqlException (0x80131904): Could not process the operation. Always On Availability Groups does not have permissions to access the Windows Server Failover Clustering (WSFC) cluster. Disable and re-enable Always On Availability Groups by using the SQL Server Configuration Manager. Then, restart the SQL Server service, and retry the currently operation. For information about how to enable and disable Always On Availability Groups, see SQL Server Books Online. Availability group '< ag_name >' failed to process remove-replica command. The operation encountered SQL Server error 35222 before the availability group configuration could be updated, and has been rolled back. Refer to the SQL Server error log for details. If this is a Windows Server Failover Clustering (WSFC) availability group, verify that the local WSFC node is online, and then retry the command. Otherwise, contact your primary support provider.
This problem was addressed in Microsoft SQL Server Cumulative Update 1.