This section describes how to add a node to the SQL Server 2022 failover clustered instance on a multi-subnet Windows Server Failover Cluster. The installation process is run on the second node of the cluster, SQLNODE-02.
To add a node on a SQL Server 2022 multi-subnet failover clustered instance:
- Run setup.exe from the installation media to launch SQL Server Installation Center.
- Click the Installation link on the bottom left. Click the Add node to a SQL Server failover cluster link. This runs the SQL Server 2022 Setup wizard.
- In the Product Key dialog box, enter the product key that came with your installation media and click Next.
- In the License Terms dialog box, click the I accept the license terms check box and click Next.
- In the Global Rules dialog box, validate that the checks return successful results and click Next.
- In the Microsoft Update dialog box, click Next.
- In the Add Node Rules dialog box, validate that the checks return successful results. If the checks returned a few warnings, make sure that you fix them before proceeding with the installation. Click Next.
- In the Cluster Node Configuration dialog box, validate that the information for the existing SQL Server 2022 failover clustered instance is correct. Click Next.
- In the Cluster Network Configuration dialog box, enter the virtual IP address and subnet mask that the SQL Server 2022 failover cluster instance will use in the network subnet that the second node is in – 10.2.0.0/24.
- In the Service Accounts dialog box, verify that the information is the same that was used to configure the first node. Click Next.
- In the Feature Rules dialog box, click Next.
- In the Ready to Add Node dialog box, verify that all configurations are correct and click Install.
- Once the installation finishes, in the Complete dialog box, click Close. This concludes adding a node to a SQL Server 2022 multi-subnet cluster.