question

souravmis avatar image
souravmis asked

Error: While creating clusterless Availbility Group

Error Message:


Msg 47106, Level 16, State 3, Line 11 Cannot join availability group '100'. Download configuration timeout. Please check primary configuration, network connectivity and firewall setup, then retry the operation. Msg 41158, Level 16, State 3, Line 11 Failed to join local availability replica to availability group '100'. The operation encountered SQL Server error 47106 and has been rolled back. Check the SQL Server error log for more details. When the cause of the error has been resolved, retry the ALTER AVAILABILITY GROUP JOIN command. Msg 15151, Level 16, State 1, Line 15


I ensure following:

  • Both SQL server are running in same windows account
  • Both accounts has sysadmin privileges.
  • All firewall settings are off and able ping and connect SQL1 and SQL2


availability groups
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered

What account are the services running as, a DOMAIN account or a LOCAL account?

Are both machines able to telnet / TNC to the endpoint port? (5022 by default)

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.