SQLTeam.com | Weblogs | Forums

ALWAYS ON Secondary Database Unable to Join


#1

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.

  1. Enabled Inbound and outbound with 5022
  2. Checked the SQL services is running under domain account and executed the grant query.

#2

Can you telnet on that port between the hosts?