Hi All,
Im trying to join a secondary database to ALWAYS on AG but its getting failure with message The Connection to the Primary Replica is not Active. Upon checking i found " An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'."
TEST\SRVR1 TCP://TEST.servers.xyz.com:5022 DISCONNECTED An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.
I tried the below steps and it didnt resolve.
- Enabled Inbound and outbound with 5022
- Checked the SQL services is running under domain account and executed the grant query.