SQL 2012 Failover Cluster Build (Step by Step) – Part 3:Adding a New Instance


This is my 3rd and last post of the series of building SQL Server 2012 failover cluster. This will cover the steps adding a new named database instance to the cluster that is already created. Please refer to the 1st part for understanding the context of the overall 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 2: Adding second node to the cluster

How-to steps

This will be very similar to SQL Server 2012 installation in part 1. So, the recommendations given there apply here as well. Assumed you logged in with a cluster admin account to Node1 or Node2.


Screen capture

1.       Start the Setup media



2.       Click Installation. Then ‘New SQL  Server failover cluster installation’



3.       OK



4.       Uncheck ‘Include SQL Server product updates’ if not connected to Internet. Then Next



5.       Next



6.       Provide the product key. Then Next




7.       Check the license agreement checkbox. Then Next



8.       Next



9.       Select Instance Features. Then Next



10.   Next



11.   Provide Network and Instance Name. Then Next






12.   Next



13.   Next






14.   Select disks needed by the instance. Then Next






15.   Check IP Type (IPv4) and provide IP Address. Then Next



16.   Provide service account credentials for engine and agent services. Then Next.



17.   Add current user as sysadmin.

Click on Data Directories tab. Then  give path to each directory




18.   Next



19.   Next



20.   Next



21.   SUCCESS. Close.





In this post, I have shared with you the scenario of adding a new database instance to the SQL Server 2012 failover cluster that is created in the part 1. This is the last piece of the post series of implementing highly available SQL data services by utilizing clusters. But, not the last on High Available (HA) data services, which is one of the major enhancements of SQL 2012 Server. There are more to say about SQL 2012 Server HA features, added some resources below. Perhaps next time, we can dive into it, stay tunedSmile

Resources on SQL Server 2012 HA

  1. High Availability Solutions (SQL Server)(http://msdn.microsoft.com/en-us/library/ms190202.aspx)
  2. Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server) (http://msdn.microsoft.com/library/ff878487(v=sql.110).aspx#SystemReqsForAOAG)
  3. SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns (http://sqlcat.com/sqlcat/b/msdnmirror/archive/2011/12/22/sql-server-2012-alwayson-high-availability-and-disaster-recovery-design-patterns.aspx)
  4. Prepare a Mirror Database for Mirroring (SQL Server) (http://msdn.microsoft.com/en-us/library/ms189053.aspx)
  5. AlwaysOn Failover Cluster Instances (SQL Server) (http://msdn.microsoft.com/en-us/library/ms189134.aspx) 

Comments (7)

  1. Mecit Atmaca says:

    @Patrick, I have used different network names used (CSQLSP and CSQLAPP) in fact. For the issue you are having, simply, you could give a different name, perhaps?

  2. Mecit Atmaca says:

    @Lara, in simplest terms, it is Windows clustering feature job as long as cluster health (no issues around connectivity, disks, sql server instances, etc.)

  3. Lara says:

    Don’t you suppose to go to the second node and add the node to the new instance you created, same steps you initially followed to adding the cluster node? If not, how the instance will fail to the second node?

  4. Patrick Wakeford says:

    In your tutorial you use the same SQL Server Network Name for both Part 1 and Part 3, when I try to do this I get an error saying, The SQL Server Failover Cluster instance name "BLA" already exists as a clustered resource, please tell me how you got around

  5. DBA says:

    but when you use different network names, it means you have different failover clusters. This isn’t the same as two instances in a single failover cluster.

  6. Alexey says:

    Good point Lara, failover won’t work if you don’t add the node

  7. Jish says:

    whats the point of Part-3?