Install a clustered SQL instance Part 3

Part 3 – Add a node to the SQL clustered instance and test failover

So we are at the final part of this article focusing on installing a failover clustered SQL instance. In case you have missed the first two articles these can found here:

Part 1 – Create a Windows Cluster

Part 2 – Install the first SQL node of the clustered SQL instance

Part 3 – Add a node to the SQL clustered instance and test failover

Adding a node to the existing cluster is a very easy operation. Before proceeding it would be nice to check:

  • Naming resolution Forward/ Reverse is working as expected for the VIP cluster names and SQL Servers

  • All the required iSCSI drives are mounted and “Online” on the server we’re adding

So we run the setup again and we choose the Add node to a SQL Server failover cluster option.

The installation steps are pretty much straightforward  and is just the case of reviewing the actual option and add a few details. So off we go:

This pretty much concludes  the installation of the second node to the cluster.

But what if we want to test a failover? It couldn’t get any easier! From the cluster manager it is sufficient to select the clustered Role SQL Server (SharePoint) in my case right click and choose move and then select the node name.. And in matter of seconds the second nodes become the owner of the clustered role as per screenshots below.

Should this not work make sure the intended nodes are selected as owners from the Role properties:

This concludes the article about installing a clustered SQL instance which offers redundancy of the SQL Server application. Next step will be to install Databases (SharePoint in my case) and create Availability Groups with Always-On which would be part of my next articles

Michele Domanico

Passionate about Virtualization, Storage, Data Availability and Software Defined Data Center technologies. The aim of Domalab.com is sharing with the Community the knowledge and experience gained with customers, industry leaders and like minded peers. Always open to constructive feedback and new challenges.

Leave a Reply

%d bloggers like this: