Sql Server Alwayson Error: This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED.

The error message you provided suggests that there’s an issue with a secondary replica in a SQL Server Availability Group. The message indicates that the secondary replica is not connected to the primary replica, and its connected state is reported as “DISCONNECTED.”

1. Network Issues: Network problems can prevent communication between replicas. Ensure that there are no network connectivity issues between the primary and secondary replicas.
2. Firewall or Port Configuration: Check if firewalls or network security rules are blocking the required ports for SQL Server communication (e.g., port 1433). Make sure the necessary ports are open.
3. Availability Group Configuration: Verify the configuration of the Availability Group. Ensure that the listener and connection URLs are correctly configured.
4. Server or Service Restart: Sometimes, restarting the SQL Server service or the entire server can help resolve communication issues.
5. Service Account Permissions: Make sure the SQL Server service accounts on both primary and secondary replicas have the necessary permissions to access the network resources.

My Solution is releated Sql Server Service Accounts are different for nodes that is the problem for me. I changed them same and error gone.