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

4 comments:

  1. A good blog always comes-up with new and exciting information and while reading I have feel that this blog is really have all those quality that qualify a blog to be a good one.
    custom essay writing service

    ReplyDelete
  2. Thanks for any other informative blog. pandora charms sale clearance Where else could I am getting that type of information parajumpers outlet written in such a perfect approach? I have a venture that I'm simply now working on, and I have been at the glance pandora jewelry 70% off clearance out for such info.

    ReplyDelete