This section describes the installation of SQL Server 2022 failover clustered instance, which is integrated with Windows Server Failover Cluster. The installation process is run on the first node of cluster SQLNODE-01.
- Run setup.exe from the SQL Server 2022 installation media to launch SQL Server Installation Center. Click the Installation link on the bottom left side.
- Click the New SQL Server failover cluster installation 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, go through the license details and 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 Install Failover Cluster Rules dialog box, validate that the checks return successful results. If the checks returned a few warnings, make sure you fix them before proceeding with the installation. Click Next.
- In the Setup Role dialog box, select the SQL Server Feature Installation option and click Next.
- In the Feature Selection dialog box, select the following component: Database Engine Services and Click Next.
- In the Feature Rules dialog box, verify that all the rules have passed. If the rules returned a few warnings, make sure you fix them before proceeding with the installation. Click Next.
- In the Instance Configuration dialog box, for this example setup, the following parameters are entered:
- SQL Server Network Name: SQLFCI
- Instance ID: SQLDBFCI
Click Next.
- In the Cluster Resource Group dialog box, check the resources available on your Windows Server Failover Cluster. This tells you that a new Resource Group will be created on your cluster for the SQL Server instance. To specify the SQL Server cluster resource group name, you can either use the drop-down box to specify an existing group to use or type the name of a new group to create it. Accept all the defaults and click Next.
- In the Cluster Disk Selection dialog box, select the available disks (the shared volumes mapped earlier to the Windows Server Failover Cluster nodes). These disks can be made available to SQL Server 2022 to use. Click Next.
- In the Cluster Network Configuration dialog box, enter the virtual IP address and subnet mask that the SQL Server 2022 cluster will use. Notice that the setup process has detected the existence of multiple network subnets.
Select the checkbox beside the IPv4 column as a static IP address will be used and click Next.
- In the Server Configuration dialog box, set the credentials for the SQL Server service accounts in the Service Accounts tab. Make sure that both the SQL Server Agent and SQL Server Database Engine services have a Startup Type of Manual. SQL Full-text Filer Daemon Launcher and SQL Server Browser are build-in accounts that do not require a password. The Windows Server Failover Cluster takes care of stopping and starting the service. Also, set the Collation property for the instance according to your application requirement. Click Next.
- In the Database Engine Configuration dialog box, select the appropriate Authentication Mode in the Server Authentication tab. If you want to add the currently logged on user to be a part of the SQL Server administrators’ group, click the Add Current User button. Otherwise, you can add the appropriate domain accounts or security groups.
- In the Feature Configuration Rules dialog box click Next.
- In the Ready to Install dialog box, verify that all configurations are correct and click Next.
- Once the installation finishes, in the Complete dialog box, click Close.