Installation of SQL Server on Cluster Nodes

  1. Go to the Cluster Node, where the Shared drive is mounted automatically by the Failover Cluster Manager and install the SQL Server Setup.

  2. Double-Click on the SQL Server Setup, then go to the Installation Tab and select New SQL Server Failover Cluster Installation.

  3. Enter the Product key. Click Next.

  4. Select the check box for accepting the License Terms. Click Next.

  5. Click Next until the user gets the Install Failover Cluster Rules wizard.

  6. Verify the status for the Tests. Click Next.

  7. Select the appropriate checkbox required. Click Next.

  8. Select the appropriate Instance radio button and provide the instance name. Click Next.

  9. Select the SQL Cluster Name from the drop-down menu. Click Next.

  10. Select the appropriate Cluster Disk. Click Next.

  11. Enter the IP address (DHCP/Static) for the cluster network.

  12. Select the Admin Username, enter the Password, and enable the checkbox for Grant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service. Click Next.

  13. Select the Mix Mode radio button, enter the password for the SQL Admin account, and select the username for SQL Admin account.

  14. Select the Data Directories Tab and verify the appropriate shared drive directory paths.

  15. Click Next for the next two wizards; the installation for SQL Status starts.

  16. After the Installation is complete, click Close.

  17. Now, perform the similar steps on the other nodes. The only change is Select Add node to a SQL Server Failover cluster from the SQL Server Setup.