• Repost - originally posted 15-05-2012

SQL Server 2012 Availability Groups Lessons Pt 2

This is the second tip for making your setup of SQL Server 2012 AlwaysOn Availability Groups easier. Tip 2: Make sure that you have opened ports on your firewalls so that the SQL Servers can communicate.

This could be internal firewalls if you have the Windows Firewall configured on your servers or it could be the external firewall at a remote location (or both).

Ideally you have already changed the default SQL Server from using port 1433.

By default the HADR endpoints are configured on port 5022 - so make sure that this TCP port is open.

If you don't use the default Hadr_endpoint port then make sure that you open the port you have configured.

If you are using a listener group and you have changed this listener port for improved security then you would need to make sure that you have this port open on your firewalls.

A current client example is:

- SQL Server TCP Port 1435

- Hadr_endpoint port 1437

- First availability group listener port 1439

- Second availability group listener port 1441

Recent Posts

See All