3 pieces in front of us. The full configuration of SQL Server Failover cluster+ AlwaysOn is described, and today we'll show you how to add multiple client access points to AlwaysOn, in general, There is only one single availability group listener (Listener) per availability group, but in some extreme cases multiple listeners may be created for the same availability group. For example, some historical problems. At this point, you may need to create an additional listener for hard coding.
However, it is not possible to create a second listener through the graphical interface (SSMS), T-SQL, or even PowerShell, which must be done using failover Cluster Manager. We create a client access point resource in our "Sqlag" role. Follow the steps below:
We open failover Cluster Manager----role---Select AG---Add resources-Client access point
We can define the client access point name and the corresponding access point IP
Confirmation information
Increased completion
At this point we can see two access names and IP addresses under the role---AG
State is partially in operation
Our resources---find that the new additions are offline
At this point we right-click the new Client Access point and select Properties:
Dependent relationships
Select the previous listener
We can right-click online
When online, we can use both listener addresses to link managed
SQL Server Failover cluster+ alwayson--Increased number of listeners
