SQL Error 47106 when trying to add a database to an Availability Group

Voltaire T February 25, 2020 0

Fix:

Ensure that Windows Firewall is not blocking TCP port 1433 (SQL) and TCP port 5022 (Replication). If so, create the necessary inbound rules for those two ports.

netsh advfirewall firewall add rule name="MS SQL Database Engine" dir=in action=allow protocol=TCP localport=1433

netsh advfirewall firewall add rule name="MS SQL Database Sync" dir=in action=allow protocol=TCP localport=5077