SQL Server Failover Cluster Installation -3

Mehmet Salih Deveci March 15, 2019 Leave a comment

Hi,

I will continue to tell SQL Server Failover Cluster Installation in this post.

Read previous article with following link.

SQL Server Failover Cluster Installation -2

You should added to the node according to the criticality of the application in the Failover Cluster architecture . In SQL Server 2008 Enterprise R2, up to a maximum of 16 nodes can be reached, this number is up to 64 in SQL Server 2012. Again, the number of nodes to be added depends entirely on the criticality of the application.

As a result, every node added means a server and the resources allocated to it. The cost increases as the number of Node increases, but High Availability increases in the face because the presence of the alternate node of each server will increase our high availability of service .

In the previous article, we have installed SQL Server Cluster on one of the two separate servers that have Windows Cluster installation. Now we are adding the same Cluster a node. The steps will be as follows.

1. In setup files, we run setup.exe as below on Second server.

2. In this step, click OK button to go on.

3. In this step, enter Product Key and click Next button.

4. In this step, click OK button to go on.

4. In this step, click Install button to start installation.

5. In this step, the necessary parameters of system and Networks are checked on Windows Cluster as shown in the picture below. If there is a problem, it will not continue or installation will be problematic. As seen below, there is no problem except for some trivial warnings because there is no problem in our establishment. Click Next button and continue.

6. In this step, the Node Configuration of the Cluster is performed. Instance Name, Node Name and Cluster Network Name values are entered. We can give the active and passive Node the name we want, but we have to enter the Cluster Name which is preset of the Cluster Name. Click Next and continue.