SQL Server 2022 : Failover Cluster Instance #12025/01/16

Configure SQL Server Failover Cluster Instance (FCI).

This example is based on the environment with 2 SQL Servers like follows.
(possible to configure with more than 3 SQL Servers)

                                   |
+----------------------+           |           +----------------------+
|  [      AD DS     ]  |10.0.0.100 | 10.0.0.110|  [  iSCSI Target  ]  |
|    fd3s.srv.world    +-----------+-----------+    tgt01.srv.world   |
|                      |           |           |                      |
+----------------------+           |           +----------------------+
                                   |
+----------------------+           |           +----------------------+
|  [ SQL Server #1 ]   |10.0.0.101 | 10.0.0.102|  [ SQL Server #2 ]   |
|    rx-7.srv.world    +-----------+-----------+    rx-8.srv.world    |
|                      |                       |                      |
+----------------------+                       +----------------------+

[1]	Configure Windows Server Failover Clustering (WSFC) on all Nodes you plan to configure Failover Cluster Instance, refer to here.
[2]	Add shared storage to WSFC that is used on Failover Cluster Instance, refer to here.
[3]	Create a domain user account on AD DS for SQL Server, refer to here. Also add the user in [Domain Admins] group. It creates [SQLAdmin] user on this example.
[4]	In the Windows firewall, allow port [1433/TCP] for the default instance.
[5]	Install SQL Server Failover Cluster Instance on a primary Node like follows. Only different sections from common StandAlone installation are shown below. Run SQL Server installation program [setup.exe] and click [New SQL Server failover cluster installation].

[6]	On the section below, Set [SQL Server Network Name]. Input any name you like.

[7]	On the section below, Set Cluster Resource Group.

[8]	On the section below, Select Cluster Disk for SQL Server Databases. It's possible to select shared storages you configured on [2] section.

[9]	On the section below, Configure Cluster Network. Set an free IP address to use for SQL Server Failover Cluster Instance.

[10]	On the section below, Configure service accounts. For [SQL Server Database Engine], [SQL Server Agent], [SQL Server Analysis Service], specify AD domain account created on [3] for them.

[11]	For others, they are the same procedures with StandAlone installation. After installing, Proceed to the secondary Node installation.

Matched Content