Enjoy Sharing

Creating a SQL Server 2012 Cluster (Part 1)

In this 2 part series I will guide you step-by-step to creating a SQL Server 2012 cluster with iSCSI as the storage. The first part is to prepare the platform in which the SQL Server will sit.

  • Install .NET Framework 3.5
  • Install Failover Clustering
  • Creating a cluster
  • Add disks to cluster

So let’s start with ensuring that you have a drive presented to your SQL nodes from the storage. I’m using a iSCSI SAN build with nothing except Windows Server 2012. If you don’t know how to do this, check my previous post here.

image

 

Make sure it is formatted and has a drive letter assigned to it on the first node.

image

 

At the Server Manager, click Add roles and features.

image

 

Click Next.

image

 

And Next again..

image

 

And Next again…

image

 

No roles to install, so just click Next.

image

 

There’s two features to install here; .NET Framework 3.5 and Failover Clustering. If ever a windows appears, click Add Features.

image

 

Remember in Windows Server 2012, when installing .NET Framework you need to specify an alternate path to the drive of the mounted Windows ISO.

image

 

Done. Repeat this for the 2nd SQL node.

image

 

Creating the Cluster

Open the Failover Clustering Manager. Right-click and then select Create Cluster.

image

 

Click Next.

image

 

Enter the two SQL nodes.

image

 

Select Yes and then click Next.

image

 

Click Next.

image

 

Select Run all tests and then click Next.

image

 

Click Next.

image

 

Click Finish.

image

 

Give it a cluster name and an IP address then click Next.

image

 

Click Next. Click to remove the Add all eligible storage to the cluster.

image

 

Click Finish.

image

 

Click Add Disk.

image

 

Click OK.

image

 

Cluster disk is ready.

image

Until part two of this series, your cluster is now up. Next in the series we will install SQL Server on top of this cluster.

 

 

 

Enjoy!!!

Advertisements

5 responses

  1. Pingback: Installing a Highly Available (Cluster) System Center Virtual Machine Manager 2012 « Teh Wei King's System Center Blog

  2. Jill

    So far we are good…….ready for part 2. Where is it?
    thanks

    December 28, 2012 at 2:52 am

    • Jill

      I found it..never mind…sorry…delete

      December 28, 2012 at 3:00 am

  3. great, in can setup server fpt by my self 🙂

    April 26, 2013 at 10:54 am

  4. I’m new in installation sql server clustering, and when i run the rules checking, it’s show error “Cluster Nodes Failed”, so base on your experience do you think what could causing this? and also i’m using window server 2012 Standard edition. I googled and found other blogger mentioned must have window server 2012 DC or Enterprise. But My BOSS think there should be fine with standard version then i STUCKED.. Thanks for your advise in advance

    November 5, 2013 at 6:09 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s