SQL Server 2012 Failover Cluster Installation – Step by Step Guide – Part 2


Good Day .. today i complete my SQL 2012 Server Lab installation, in part 1 of this article we have prepared our environment for the SQL installation, and as agreed we are going to use the Integrated Installation method.

Before we start the installation we need to install .Net framework 3.5 on both SQL nodes otherwise the installation will fail. to do that we will use Server Manager to add features.

Click to specify an alternate path for the .Net framework installation files.

21Insert the CD for the Windows Server 2012 R2 and type in the path for the .NetFramework files under \Sources\SXS

22Finalize the setup on both nodes.


Iam going to use a SQL 2012 SP1 media, Load your media and fire up the installation. Choose to install a New SQL Server failover cluster installation

1Fix any errors you receive before proceeding with the installation.

2Type in your product Key and continue, i will be installation the Evaluation edition.

3Now this is a new step in the SQL Server installation that downloads updates for the SQL Server installation.


Wait for the updates to be downloaded if any, and proceed with the install setup files step.

5Check for any warnings or errors to repair.

6Select SQL Server Feature Installation

7Select the features you require.

8Review any problems that might block this setup based on the selected features.

9Choose the Virtual name for the SQL Server that will be used by your applications or users.

10Specify the name for the SQL Server cluster resource group.

11Select the Disks that would be added to the Cluster group, the first disk will automatically be used as the default location for all Databases.

12Specify the cluster network and the IP Address for your SQL Cluster.

Now define the Logon account for each SQL Service, If you configure services to use domain accounts, Microsoft recommends that you configure service accounts individually to provide least privileges for each service, where SQL Server services are granted the minimum permissions they need to complete their tasks. Please review the Server Configuration – Service Accounts for Service Accounts explanation and requirements. for my lab i am using the same account for all services.

14I am going to use Windows mode authentication.

15Choose the Database and Logs location.

16Specify both the Service Account and Data location for the analysis services.

17Click next to only install the Report server files, after the installation use the Sharepoint Central Administration to complete the configuration.

18Ok we are fine with the Rules check.


Confirm to start the installation , Setback and wait 🙂

20The installation should go smoothly.

24You can see the SQL CLuster group is automatically created.


Now let’s start adding the Second node to the SQL Cluster. Launch the SQL installation from the second node.

Click on  Add node to a SQL Server failover cluster

26Installation steps are the same, so i am not going to repeat them. i will only list any additional steps.

27Confirm and start the installation for the second node.

28We are done…

29You can select a preferred node for your cluster if required, test your SQL Cluster group failover between the two nodes

30Open the SQL Server Management Studio and connect to the Virtual name for the SQL cluster that you have chosen during the installation.

31With this step i am finalizing this article, i hope it was informative.


Related Articles

SQL Server 2012 Failover Cluster Installation – Step by Step Guide – Part 1

Follow TAG on Facebook for the latest articles ( TAG on Facebook )


3 thoughts on “SQL Server 2012 Failover Cluster Installation – Step by Step Guide – Part 2

  1. Thank You!!

  2. Really awesome. As per this article, does that mean SQL-01 is active and SQL-02 is passive node?

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s