How to install a clustered SQL Server 2012 Instance – step-by-step – Part 3

Dec 19, 2013 / By Murilo Miranda

Tags: , , , , ,

In continuation of our series on how to install a SQL Server 2012 clustered instance, let’s discuss how to add a node into an existing SQL Server clustered instance. The following steps are performed either to add one more node to some already installed clustered instance, or to continue the installation of a brand new clustered instance — It all boils down to the same thing. To perform this phase, you will need to have at least one node installed. In this case, we installed a new SQL Server failover instance in the Part 2 of this series.

So connect to the next node, in this case W2012SRV04, and perform the following steps:

1. Make sure that you have the same SQL Server 2012 media used to install in the other node available and execute the “Setup” binary.

Screen Shot 2013-12-09 at 12.38.542. The “SQL Server Installation Center” will be opened.

Screen Shot 2013-12-09 at 12.39.28

3. Still on “SQL Server Installation Center”, click “Installation” and select “Add node to a SQL Server failover cluster”.

Screen Shot 2013-12-09 at 22.38.41

4. A check will run in order to verify the setup support rules. Click “OK”.

Screen Shot 2013-12-18 at 14.46.07

5. Now the setup will check and install the latest updates. Keep the “Include SQL Server product updates” checked and click “Next”.

Screen Shot 2013-12-09 at 22.39.51

6. Another check will run in order to identify problems within the installation process. Click “Next”.

Screen Shot 2013-12-09 at 22.42.01

7. Insert the product key and click “Next”.

Screen Shot 2013-12-09 at 22.42.17

8. Accept the terms and click “Next”.Screen Shot 2013-12-09 at 22.42.28

9.  On this step you need to pick the instance where this installation will be related. Notice that you have a list of installed instances, as well as the nodes that the instances are already installed.
In our case, the Instance Name “DB” is installed in only one node, and we need to choose this instance in the list box in the top to proceed to the node addition.

Screen Shot 2013-12-09 at 22.44.13

10. Now. confirm the IP settings as you did in the first node installation. Click “Next”.

Screen Shot 2013-12-09 at 22.45.02

11. Fill the passwords for the Engine and Agent service account, and click  “Next”.

Screen Shot 2013-12-09 at 22.45.36

12. Like in the other (first) node, you have the option to send error reports to Microsoft. Click on “Next”.

Screen Shot 2013-12-09 at 22.46.14

13. Now the setup will verify if the installation process can be blocked. In the end, click “Next”.

Screen Shot 2013-12-09 at 22.46.26

14. Review the options and click on “Install”.

Screen Shot 2013-12-09 at 22.46.47

15 Now you can watch the installation progress. Click “Next” when it is done.

Screen Shot 2013-12-09 at 22.47.00

16. Now the node addition is complete! Just verify if all of the features have succeeded. Click “Close” and you are done!

Screen Shot 2013-12-09 at 22.56.08

At the end of this installation, you will have one more node available to run out our instance. This means that we can now perform a failover from W2012SRV03 to W2012SRV04, so we have now a high availability (HA) solution. In case of a hardware failure on the active node, we will have a failover action.

For some reason, such as a test or for maintenance purposes, you can do a failover manually. To perform this, open the Failover Cluster Manager tool (the same used on step 2), right-click over the role name (in our case “SQL Server (DB)” and then select the “Move” option. Two options will be shown — the first “Best Possible Node” and the second one “Select Node…” Both are valid, but the second gives you the chance to choose the node to move the Role, which is useful when you have more than two nodes.

Screen Shot 2013-12-18 at 16.38.27

That’s it for today. I will be back soon with the last part of this series, talking about MS DTC on clustered instances.

If you want to check the other parts of this series, here are the links:

3 Responses to “How to install a clustered SQL Server 2012 Instance – step-by-step – Part 3”

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>