I was trying to create Clusterless AlwaysON for SQL Server 2019 and getting the below error.
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
- All firewall settings are off and able ping and connect SQL1 and SQL2