Breadcrumbs

Installation of SQL Server on Cluster Nodes

  1. Go to the Cluster Node, where Shared drive is mounted automatically by 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 till the user gets 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 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

SQL Statement
SQL
USE Testdb;

CREATE ASYMMETRIC KEY 'RSA2048Key1'

FROM PROVIDER utimaco

WITH ALGORITHM = RSA_2048,

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

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

  3. Click Next for next two wizards, the installation for SQL Status starts

  4. After Installation is complete, Click Close

  5. 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