Team blog of MCS @ Middle East and Africa

This blog is created by Microsoft MEA HQ near shoring team, and it aims to share knowledge with the IT community.With its infrastructure and development sides,It brings to you the proven best practices and real world experiences from Subject Matter Experts
Follow Us On Twitter! Subscribe To Our Blog! Contact Us

SQL 2012 Failover Cluster Build (Step by Step) – Part 2: Adding a New Node

SQL 2012 Failover Cluster Build (Step by Step) – Part 2: Adding a New Node

  • Comments 4
  • Likes

Introduction

This is my 2nd post of the series of building SQL failover cluster. This post covers adding second node to the SQL Server 2012 failover cluster that is created in Part 1. Please refer to the 1st part for understanding the context of this demonstration. You must finish part 1 in order to apply the steps defined here in your case.

Part 1: Installing SQL Server 2012 failover cluster

Part 3: Adding a New Instance to Cluster

How-to steps

Please note that Node 1 and Node 2 are interchangeable identifiers for clusters nodes. Important point is that part 1 is to be executed on node 1 and this steps  is to be done on the other node. Make sure you login with the cluster admin account defined in your domain.

Step#

Screen capture

1- Start your SQL 2012 Server installation media on Node 2 and Click 'Installation'

clip_image001[4]

2. Click 'Add node to a SQL Server failover cluster' link on the right

clip_image002[4]

3. OK (fix if any Failed found, of course)

clip_image003[4]

4. Next

clip_image004[4]

5. Setup Support Rules

Wait for Rules check. Once done make sure no failed task. Evaluate warnings for your environment (remember the VM is not connected to Internet). Then click Next

clip_image005[4]

6. Provide PK key. Then Next

sql 2012 PK part 2

7. Check the 'I accept the license terms'. Then Next

clip_image007[4]

8. Next

clip_image008[4]

9. Next

clip_image009[4]

10 - Provide engine and agent service account passwords. Then Next

clip_image010[4]

11. Next

clip_image011[4]

12. Next

clip_image012[4]

13. Evaluate the settings. Then Install

clip_image013[4]

14. SUCCESS. Close.

clip_image014[4]

Conclusion

In this article, we have demonstrated adding a second node into the cluster. I am sure you have also found it straight forward and easy to accomplish. Right?

Take care and see you in the next post.

Comments
  • Nice information

  • Awesome post!  Thanks!

  • If you want to add a DR servers, do you need to create another cluster on DR to identical to Prod or add the DR nodes to the existing cluster? e.g. cluster is active/active on Prod

  • @CoolDBA, Please note that SQL 2012 release introduced dramatic changes on terms and architecture. There are significant enhancements made with this release regarding HA and DR. What you could do is to have a multisite failover cluster (yes, nodes can be dispersed geographically) utilizes Availability Groups (that replaces mirroring and log shipping) by implementing SQL 2012 AlwaysOn feature. Please check here for further details: <a href="msdn.microsoft.com/.../ff929171.aspx"> Failover Clustering and AlwaysOn Availability Groups (SQL Server) </a>

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment