You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: azure-sql/includes/virtual-machines-ag-listener-configure.md
+8-7Lines changed: 8 additions & 7 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -7,7 +7,7 @@ ms.topic: include
7
7
---
8
8
The availability group listener is an IP address and network name that the SQL Server availability group listens on. To create the availability group listener, do the following:
9
9
10
-
1. <aname="getnet"></a>Get the name of the cluster network resource.
10
+
1. <aname="getnet"></a>Get the name of the cluster network resource:
11
11
12
12
a. Use RDP to connect to the Azure virtual machine that hosts the primary replica.
13
13
@@ -17,7 +17,8 @@ The availability group listener is an IP address and network name that the SQL S
17
17
18
18
:::image type="content" source="./media/virtual-machines-ag-listener-configure/90-cluster-network-name.png" alt-text="Screenshot that shows a cluster network name in Failover Cluster Manager.":::
19
19
20
-
1. <aname="addcap"></a>Add the client access point.
20
+
1. <aname="addcap"></a>Add the client access point.
21
+
21
22
The client access point is the network name that applications use to connect to the databases in an availability group. Create the client access point in Failover Cluster Manager:
22
23
23
24
a. Expand the cluster name, and then select **Roles**.
@@ -45,7 +46,7 @@ The availability group listener is an IP address and network name that the SQL S
45
46
46
47
:::image type="content" source="./media/virtual-machines-ag-listener-configure/96-ip-resource.png" alt-text="Screenshot of Failover Cluster Manager that shows the selection of an IP address.":::
47
48
48
-
1. <aname = "dependencyGroup"></a>Make the SQL Server availability group dependent on the client access point.
49
+
1. <aname = "dependencyGroup"></a>Make the SQL Server availability group dependent on the client access point:
49
50
50
51
a. In Failover Cluster Manager, select **Roles**, and then select your availability group.
51
52
@@ -57,17 +58,17 @@ The availability group listener is an IP address and network name that the SQL S
57
58
58
59
d. Select **OK**.
59
60
60
-
1. <aname="listname"></a>Make the client access point dependent on the IP address.
61
+
1. <aname="listname"></a>Make the client access point dependent on the IP address:
61
62
62
63
a. In Failover Cluster Manager, select **Roles**, and then select your availability group.
63
64
64
65
b. On the **Resources** tab, right-click the client access point under **Server Name**, and then select **Properties**.
65
66
66
67
:::image type="content" source="./media/virtual-machines-ag-listener-configure/98-dependencies.png" alt-text="Screenshot of Failover Cluster Manager that shows the Properties menu option for the listener's name.":::
67
68
68
-
c. Select the **Dependencies** tab. Verify that the IP address is a dependency. If it isn't, set a dependency on the IP address. If there are multiple resources listed, verify that the IP addresses have **OR**, not **AND**, dependencies. Select **OK**.
69
+
c. Select the **Dependencies** tab. Verify that the IP address is a dependency. If it isn't, set a dependency on the IP address. If multiple resources are listed, verify that the IP addresses have **OR**, not **AND**, dependencies. Select **OK**.
69
70
70
-
:::image type="content" source="./media/virtual-machines-ag-listener-configure/98-properties-dependencies.png" alt-text="Screenshot of the Dependencies tab that shows an IP resource for the availability group.":::
71
+
:::image type="content" source="./media/virtual-machines-ag-listener-configure/98-properties-dependencies.png" alt-text="Screenshot of the Dependencies tab that shows an IP resource for an availability group.":::
71
72
72
73
>[!TIP]
73
74
>You can validate that the dependencies are correctly configured. In Failover Cluster Manager, go to **Roles**, right-click the availability group, select **More Actions**, and then select **Show Dependency Report**. When the dependencies are correctly configured, the availability group is dependent on the network name, and the network name is dependent on the IP address.
@@ -128,7 +129,7 @@ If necessary, repeat the preceding steps to set the cluster parameters for the I
128
129
129
130
b. Set the cluster parameters by running the PowerShell script on one of the cluster nodes.
130
131
131
-
If any SQL resource is configured to use a port between 49152 and 65536 (the [default dynamic port range for TCP/IP](/windows/client-management/troubleshoot-tcpip-port-exhaust#default-dynamic-port-range-for-tcpip)), add an exclusion for each port. Such resources might include the SQL Server database engine, Always On availability group listener, failover cluster instance's health probe, database mirroring endpoint, and cluster core IP resource. Adding an exclusion will prevent other system processes from being dynamically assigned to the same port. For this scenario, configure the following exclusions in all cluster nodes:
132
+
If any SQL resource is configured to use a port between 49152 and 65536 (the [default dynamic port range for TCP/IP](/windows/client-management/troubleshoot-tcpip-port-exhaust#default-dynamic-port-range-for-tcpip)), add an exclusion for each port. Such resources might include the SQL Server database engine, Always On availability group listener, health probe for the failover cluster instance, database mirroring endpoint, and cluster core IP resource. Adding an exclusion will prevent other system processes from being dynamically assigned to the same port. For this scenario, configure the following exclusions on all cluster nodes:
132
133
133
134
-`netsh int ipv4 add excludedportrange tcp startport=58888 numberofports=1 store=persistent`
134
135
-`netsh int ipv4 add excludedportrange tcp startport=59999 numberofports=1 store=persistent`
0 commit comments