Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
This topic describes how to view the properties of an AlwaysOn availability group listener by using SQL Server Management Studio or Transact-SQL in SQL Server 2016.
Availability Group Listener Properties (Dialog Box)
Listener DNS Name
The network name of the availability group listener.
The TPC port used by this listener.
If you are connected the primary replica, you can use this field to modify the port number of the listener. This requires ALTER AVAILABILITY GROUP permission on the availability group, CONTROL AVAILABILITY GROUP permission, ALTER ANY AVAILABILITY GROUP permission, or CONTROL SERVER permission.
Indicates the TCP protocol used by the listener, one of:
The listener uses an dynamic IP address that is assigned by a server running the Dynamic Host Configuration Protocol (DHCP).
The listener uses one or more Static IP addresses. To access the different subnets, an availability group listener must use static IP addresses.
The grid displays each of the subnets on which the listener listens and the IP address associated with that subnet.
For a given availability group, returns either zero rows indicating that no network name is associated with the availability group, or returns a row for each availability-group listener configuration in the WSFC cluster.