Install SQL 2014 SP1 Failover cluster for Operations Manager

The two-node SQL Server failover cluster used for the SCOM operation databases will be installed on cluster VSCluster, The two nodes used for this cluster are Node 1 and Node 2.

Prerequisites

  • The windows failover clustering role is installed and configured on both nodes” Documents Install Windows 2012 R2 Failover Cluster Should be done.”
  • Needed SAN disks are by both nodes and multipath is configured.
  • The account Domain\SQL_Account is in the local administrators group on both nodes.
  • SQL Server 2014 SP1 sources are copied locally on both nodes.

Installation steps

On the failover cluster management right click to the cluster name select configure role.


On the High Availability wizard click next.


Select Distrusted transaction coordinator (DTC) then click next.


Write the MSDTC name and enter the IP of the DTC.


Select the dedicated disk for MSDTC resource.


Click next.


Verify the configuration then click finish.


Make sure that all the resources online.


Right click on MSDTC role select Move, Select node.


Select the other node then click ok to test the failover.


Right-click on MSDTC role and select Properties..


Make sure both nodes are checked as preferred owners and that DTCCluster is at the top of the list. Then go to the Failover tab..


Set the Maximum failures in the specified period to 3 and adjust the period to 1 hour. Make sure to select Allow failback immediately.


Log on the first node Launch the SQL Server setup (right click, Run as Administrator).


Go to the Installation pane and select New SQL Server failover cluster installation.


Enter the Product key then click next.


Check I accept the licensing terms then click next.

In the Setup Support Rules dialog box, validate that the checks are all successful.


Uncheck use Microsoft update to check for update (recommended) Then click next.


You will receive an error, Please ignore it and click next.


On the Setup Support Files click on Install.


Make sure all checks are successful. The warning status for the check Microsoft cluster service (MSCS) Cluster verification error. Can be ignored.


Select Database Engine Services and Management Tools components and modify the installation directories to be on the D:\ drive.


Verify that the feature rules test passed, then click next.


Enter the SQL Server Network Name DBCluster, leave the default setting for the Instance ID and make sure the instance root directory is on the D:\ drive.


Use the default name for the SQL Server cluster resource group name.


Select the cluster disk resource dedicated to the SQL installation

Make sure to use the IPv4 adress xxx.xxx.xxx.xxx for the cluster network configuration.

Configure the SQL Server Database Engine and the SQL Server Agent services to use the Domain\SQL_Account service account and go to the Collation tab.


Make sure to select the SQL_Latin1_General_CP1_CI_AS collation for the Database Engine.


Select the Windows authentication mode, configure the account Domain\SQL_Account and SCOM_SQL_Admin Group as the SQL Server administrator and go to the Data Directories tab.


Configure the directories.


Make sure all checks are successful and validate


Click on Install to launch the SQL Server installation on the first node

Validate that all components are correctly installed and Click on Close to leave the wizard.


Open the Failover Cluster Management console, click on SQL Server (MSSQLSERVER) and make sure all dependencies are online.


Log on the second node with an administrator account. Launch the SQL Server setup, go to the Installation pane and select Add node to a SQL Server failover cluster.


Enter the product key.


Check I accept the licensing terms and validate.


Make sure all checks are successful and ignore the warning again.


Uncheck Use


Leave the default settings on the Error and Usage Reporting page

Make sure all checks are successful and validate.

Select the MSSQLSERVER instance.

Insure that you are use IPv4 input the SQL IP then click next.

Configure the SQL Server Database Engine and the SQL Server Agent services to use the Domain\SQL_Account service account.

Make sure all checks are successful and validate.

Click on Install.


Make sure all components are installed successfully, Close the wizard.


Open the Failover Cluster Management console, right-click on the SQL Server (MSSQLSERVER) application and click on Properties.


Make sure both nodes are checked as preferred owners and that DBCluster is at the top of the list. Then go to the Failover tab.


Set the Maximum failures in the specified period to 3 and adjust the period to 1 hour. Make sure to select Allow failback immediately.


Start test cluster failover.


Move cluster.

Insure that all the disks and SQL services are working and online on the second node.

Advertisements

Leave a Reply Please

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