Home » HowTo » SQL second node cluster instance install Part 3

SQL second node cluster instance install Part 3

SQL Failover Cluster Installation

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

So we are at the final part of this article focusing on installing a failover clustered SQL instance hence a SQL second node. 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 SQL 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 options and add a few details. So off we go.

Let’s run the main SQL setup binary and let’s choose the option to add a SQL node.

At his point the wizard is detecting the actual configuration and will propose the pertinent options to configure. As per previous article in this case we can ignore clustering the MSDTC service as not strictly required.
We need to select the name of the SQL Cluster instance. As per previous article is “SharePoint” in this case.

This pretty much concludes the installation of the SQL 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 of SQL Server (SharePoint) in my case right click and choose the “move” option. Then select the node name to failover to. And in matter of seconds the SQL node will become the owner of the clustered role as per screenshots below.

Should this not work let’s make sure the intended nodes are selected as the owners from the SQL Role properties. From this screen we can now choose the SQL node to run the SQL role:

About the author

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.

Add Comment

Click here to post a comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Browse articles

June 2023
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  

Articles by Category

Archives

error: Content is protected !!
%d bloggers like this: