How to Install a Clustered SQL Server 2012 Instance – Part 1

Posted in: Microsoft SQL Server, Technical Track

In this series, I will demonstrate how to install a SQL Server 2012 clustered instance in a cluster of two nodes. In general, the installation will be done in two parts:

  1. New instance installation in one of the nodes.
  2. Add the other node to the existing clustered instance.

For a cluster with more than two nodes, we would need to perform the first step in one of the nodes, and repeat the second step on all other nodes. What is a clustered instance? Basically, a clustered instance is a SQL Server instance installed over a Windows Failover Cluster (WFC) service. The main purpose of a WFC solution is protect our systems from hardware failures. In a scenario of a cluster with two nodes, we are talking about two servers, with similar hardware configuration, connected by a Failover Cluster service. Having one SQL Server instance installed over this solution, we can call this instance as a clustered instance. That clustered instance must be active in only one of the available nodes, and this means that the other nodes will be in IDLE mode, with no active functions. Another important point is that the WFC accepts shared storage, which means that we need a SAN to store the database files (logs and data). However, the SQL Server binaries generated by the installation should be in a local disk. Other than shared storage, we also have an option to store our database files into a SMB Fileshare, which is cheaper, but not as good as a solution using SAN. From SQL Server 2012 we have an option to store the TempDB isolated in a local disk, which brings lots of benefits. This way, the WFC is a high availability solution and not a load balancing or a disaster recovery solution. We can reach this by having an AlwaysOn configuration, available from SQL Server 2012. Assumption I’m assuming that at this point we already have a built cluster solution with two or more nodes. Normally, the DBA receives the environment ready to install the clustered instance. The WFC build is usually made by the System Administrators. However, I’m planning on doing another article explaining how to configure a WFC solution. Stay tuned! Prerequisites Before we start the installation, we need to assure that we have the following items ready to be used:

  • A virtual hostname. In our example we will use “SQL04”.
  • A virtual IP, a.k.a vIP. We will use:
  • Available shared storage. The best practice is have, at least, one for Data files (mdf and ldf), one for Log files (ldf) and one for Tempdb files. On this guide I will use one disk for everything, to simplify, but this is a bad approach!
  • Service Accounts: One for SQL Server Engine and another for SQL Server Agent (this is the best practice). We will use the following accounts: SSLAB\SVCSQLSRVENG and SSLAB\SVCSQLAGT.
    • Notice that the service accounts are domain accounts. We have no other choice, to build a cluster we need to be part of a domain!

Our Environment On this step-by-step guide, we will use the following environment – based in virtual machines:

  • Windows Server 2012 R2 nodes:
    • W2012SRV03 –
    • W2012SRV04 –
  • The both nodes are part of the following cluster:
    • W2012CLT02 –
  • Storage:
    • As this is a lab, I’m using a Synology Diskstation as my SAN. Just for information, the IP is:
  • For SQL Server:
    • vHostname – SQL04
    • vIP –
    • Version: Microsoft SQL Server 2012 (SP1) – 11.0.3128.0 (X64)  –  Enterprise Edition

    Screen Shot 2013-12-12 at 12.03.53

Installation Permissions for the used login To install the SQL Server I’m using the domain login called “SSLAB\dba”, which is part of the Administrators group on W2012SRV03 and W2012SRV04. The login “SSLAB\dba” is a simple user into the domain, without special permissions.

Next step

Next, find the second blog post in this series, Step-by-Step Installation of a SQL Server 2012 Clustered Instance — Part 2.
Then find the third blog post in this series, Step-by-Step Installation of a SQL Server 2012 Clustered Instance — Part 3.
Finally, find the fourth blog post in this series, Step-by-Step Installation of a SQL Server 2012 Clustered Instance — Part 4.


Pythian is a global leader in data consulting and managed services. We specialize in optimizing and managing mission-critical data systems, combining the world’s leading data experts with advanced, secure service delivery. Learn more about Pythian’s Microsoft SQL Server expertise or check out some more SQL Server-related blog posts.

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

Inspired by his father, Murilo has been passionate about IT since he was a child. When he broke their first PC at the age of 10, he was able to fix it on his own without his father finding out. Murilo’s passion for working with people coupled with his honesty have helped him establish effective, meaningful relationships with his clients. His colleagues can depend on him for any system-related issues, especially if it’s configuring a system from scratch. When he isn’t working, he can be found enjoying life with his family and watching football.

12 Comments. Leave new

Thank you for the detailed information.Could you please post link to part 2

Murilo Miranda
December 16, 2013 5:37 pm

For sure Shruthi,
I’m just finishing the last details of this post.

Keep tuned.


Thank you so much :)


Is this Active/Active Cluster?

Murilo Miranda
January 9, 2015 9:27 am

In this case, we have only one clustered instance. What people call “Active-Active” cluster, is a Cluster, with two nodes, and two different clustered instances installed, and active each one on each node. So, to achieve this, you just need to install a clustered instance two times.


Does SQL Server to be Enterprise edition only for installing the SQL Server Clustering solution for HA ?


good article


Thanks, part 1 is really helpful. Will explore part 2


mssql 2012 developer edition wll support for failover cluster setup?


Part 1 is nicely described…thx for your efforts..going to explore part 2 now.


Your E drive is it in SAN where you used it for SQL Data? If yes, I have an error which E drive not found in Node2 during add node. Please advice. Thanks.


Thanks Murilo, wondering if we can use this feature using Microsoft SQL Server standard edition as well , Provided we configure only 2 nodes in the cluster


Leave a Reply

Your email address will not be published. Required fields are marked *