Search This Blog

Friday, October 27, 2017

Error 41106: Failed to Join the Availability Group for SQL Always On

If you encountered the following error when add replica to Availability Group

Error 41106


Try to turn off Windows firewall on both nodes. Open "Windows Firewall with Advanced Security".
Turn off Domain Profile
Turn off Private Profile
Turn off Public Profile


Retry to add again. Now you should be successful.

To open windows firewall traffic, create a new inbound rule | Add Port | 5022 | TCP | Apply to specific local ports: 5022

That should do the trick! 

Hope this work