Installation of SQL Server Failover Cluster on Node 1

Step 1: To install the SQL server on mount the ISO of SQL server and double click on it. Below page will open select the Installation and click on New SQL Server fail-over cluster installation.

Step 2: In this screen enter the product key (if you have purchased then key filled automatic) and click on next button. In production environment always use licensed copy of server.

Step 3: Accept the License terms and click on next button

Step 4: In this screen we can see that all the rules have been passed just click on next button

Step 5: Here you can select Microsoft Updates options if you are connected to the internet or leave it and just click on next button, in our case we are not connected to the internet so can ignore it.

Step 6: Here SQL checks all the perquisites for installation, warning section can ignore, make sure that .net framework 3.5 with SP1 install on server before installing SQL Server.

Step 7: In this step by default SQL Server Feature Installation is selected, just review and click on next button

Step 8: In this step select all features and click on next button

Step 9: In this step we see that all rules haves been passed. Just click on next button

Step 10: In this step we configure the Instance configuration, here we can change the name of instance or leave it default, and in our case we are taking default instance. Click on next button

Step 11: In this step we have to configure the SQL service account. In our case we have taken the Administrator account for SQL service. We can also different account here (account with administrative rights of Windows Server and SQL Server). And then click on next button

Step 12: In this step select the Mixed Mode and make a strong password for SQL admin, after that click on Add Current User and then click on Next button

Step 13: Here also click on Add Current User and then click on Next button

Step 14: Here just review and leave default settings and click on next button

Step 15: Here check that all features rules passed successfully and click on Next button

Step 16: Here click on install button to install the SQL server

Step 17: Now SQL Server installation has been completed. Click on close button.

Installation of SQL Server Failover Cluster on Node 2

To add Node to fail-over clustering Open the Installation setup, select installation and then click on Add node to a SQL Server fail-over cluster.

Now to add Node follows the all the above steps that use in First Node.

One Account for SQL Server

SQL Server services should be running on same account on all nodes. For this how to add same account for SQL Server services see the below steps.

Open the SQL Server configuration manager. We need to change the service account for SQL server services.

Right click on SQL server service, select properties, go to log on tab, click on Browse button, click on location select Entire Directory and click on ok, now type the name Administrator and click on check names and click on ok, then click on apply button it will ask that SQL service need to restart to applicable this, just click on yes and then on o button.

Verify the Cluster is working

Above image is showing that SQL Server fail-over clustering is working fine.