Skip to content

Commit 35233f8

Browse files
committed
edit pass: sql-vm-ag-docs
1 parent aaf1b41 commit 35233f8

3 files changed

Lines changed: 141 additions & 138 deletions

File tree

azure-sql/includes/virtual-machines-ag-listener-configure.md

Lines changed: 8 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@ ms.topic: include
77
---
88
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:
99

10-
1. <a name="getnet"></a>Get the name of the cluster network resource.
10+
1. <a name="getnet"></a>Get the name of the cluster network resource:
1111

1212
a. Use RDP to connect to the Azure virtual machine that hosts the primary replica.
1313

@@ -17,7 +17,8 @@ The availability group listener is an IP address and network name that the SQL S
1717

1818
:::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.":::
1919

20-
1. <a name="addcap"></a>Add the client access point.
20+
1. <a name="addcap"></a>Add the client access point.
21+
2122
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:
2223

2324
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
4546

4647
:::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.":::
4748

48-
1. <a name = "dependencyGroup"></a>Make the SQL Server availability group dependent on the client access point.
49+
1. <a name = "dependencyGroup"></a>Make the SQL Server availability group dependent on the client access point:
4950

5051
a. In Failover Cluster Manager, select **Roles**, and then select your availability group.
5152

@@ -57,17 +58,17 @@ The availability group listener is an IP address and network name that the SQL S
5758

5859
d. Select **OK**.
5960

60-
1. <a name="listname"></a>Make the client access point dependent on the IP address.
61+
1. <a name="listname"></a>Make the client access point dependent on the IP address:
6162

6263
a. In Failover Cluster Manager, select **Roles**, and then select your availability group.
6364

6465
b. On the **Resources** tab, right-click the client access point under **Server Name**, and then select **Properties**.
6566

6667
:::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.":::
6768

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**.
6970

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.":::
7172

7273
>[!TIP]
7374
>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
128129

129130
b. Set the cluster parameters by running the PowerShell script on one of the cluster nodes.
130131

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:
132133

133134
- `netsh int ipv4 add excludedportrange tcp startport=58888 numberofports=1 store=persistent`
134135
- `netsh int ipv4 add excludedportrange tcp startport=59999 numberofports=1 store=persistent`

0 commit comments

Comments
 (0)