KB Issue

The Always On High Availability Group wizard, if not correctly set up, will cause the error to happen. Make sure you properly set up all SQL Server replicas for the group to function correctly.

Issue Details

Detected Issue
Data synchronization state of some availability database is not healthy.
Description
At least one availability database on this availability replica has an unhealthy data synchronization state. If this is an asynchronous-commit availability replica, all availability databases should be in the SYNCHRONIZING state. If this is a synchronous-commit availability replica, all availability databases should be in the SYNCHRONIZED state.

Recreate Issue

When running the [Always On High Availability Group] Wizard, the servers were improperly configured, which caused the errors. Unless you correctly set up [Always On High Availability Group], this error will continue to show, even after running the [Resolve Issue] below.

Resolve IssueFor each of the SQL Instances

Right-Click and choose [New Query]
For each database in the SQL Instance, run this command.
(Change DB Name to each of your database names, and the SQLGroup to the name of your SQL Group Name)

[SQK Server - Change DB Name]

CFFCS | CarrzSynEdit: | SQL Script

ALTER DATABASE DB Name-1 SET HADR AVAILABILITY GROUP = SQLGroup
ALTER DATABASE DB Name-2 SET HADR AVAILABILITY GROUP = SQLGroup
ALTER DATABASE DB Name-3 SET HADR AVAILABILITY GROUP = SQLGroup
ALTER DATABASE DB Name-4 SET HADR AVAILABILITY GROUP = SQLGroup