Building a SQL Server 2008 R2 Cluster: Part VI


With Part-V of this series on Failover Cluster installation, the two-nodes windows 2008 cluster is up and running. Before continuing further, there is a small update on the installation prerequisites of SQL Server 2008 R2. The following three components are need to be installed on the server before starting the installation (some of these components can be added during installation; however to speed-up the time required to complete the installation, install these components before starting the failover cluster installation). The required components are Dot Net Framework 3.5 SP1, Windows Installer 4.5, and PowerShell v 1.0. As Windows installer 4.5 & PowerShell v 1.0 was already installed on both the node, we need to install Dot Net Framework 3.5 SP1 on both the nodes.

To begin the Failover cluster installation, first we need to create the service accounts of the SQL Server Services (Database Engine Service Account and SQL Agent Service accounts). Create two domain user accounts to run the SQL Server Services, DBC01_AG & DBC01_DE for the SQL Agent Service & SQL Server Database Engine Service Accounts. Make sure you have added the Database Engine Service Accounts to the following policy on the individual nodes, Lock Pages in Memory & Perform Volume Maintenance Task. Once the Local policies are set, assign the Database Engine Service account with read and write permission on the SQL Server installation drive and on all the drives required for further configuration. The SQL Agent Service account should have minimum read permission on the drive.

Add the MSDTC service on the primary node. Right click on the Services and Application and select Configure a Service or Application from the available menu. Click on Next and select Distribution Transaction Coordinator from the available menu. Provide the Name and IP Address for the DTC service as shown below and click on Next to continue.

Select the drive to install the DTC service, we have added a shared disk for the same and rename the disk resource as MSDTC. Select the drive and click on Next to continue.

Verify all the available configuration and click on Next to start the DTC service installation. Once the installation is completed successfully, we will get the following screen.

Since we have configured the MSDTC service successfully, time to initiate the Failover Cluster installation for SQL Server 2008 R2. To begin with, make sure all the disk resources are online and current present on your first node, in our case, its BLRC100. Start the installation from the SQL Server 2008 R2 installation media, select New SQL Server Failover Cluster Installation from the available option, as shown below.

The SQL Support files verifies the existing setup for the SQL Server installation and you will be asked to enter the product key for the SQL Server Setup. We are going to use the SQL Server 2008 R2 Enterprise Evaluation Edition to complete this cluster setup. Accept the License Agreement and continue to load the SQL Server setup support files. It verifies the existing hardware and software requirements and provide a detailed report about any existing issues. Click on Next to select the features of the SQL Server you want to install as shown below:

Provide the Network Name of the SQL Server and click on Next to continue.

Validate the disk space requirements for the cluster and click on Next to Create the Resource Group for the failover cluster installation. For the current setup, we are going to continue with the default configuration.

Select the shared disk drive for the failover cluster installation as shown below.

Enter the IP Address for the SQL server cluster and click on Next to continue.

For our test environment, we are going to use Service SIDs. Click on Next to continue further.

Enter the Service accounts details and password to start the SQL Server Service & SQL Server Agent Service.

Add the user/group to the SQL Server Administrator; with SQL Server 2008 onwards, the Windows Server Administrators are, by-default not a member of SQL Server Administrators. Make sure, to enable the Filestream option for the Database Engine Service Account.

A setup of rules will be executed to verify whether the setup for the Failover Cluster installation will be blocked or not. Verify the SQL Server 2008 R2 features details and click on Install to start the SQL Server Failover Cluster installation. The configuration file can be used for script based installation of failover cluster.

Once the SQL Server failover cluster installation completed successfully, we will get the following screen:

If you will open the failover cluster administrator from Administrative Tools,  you will see the following screen-shot, when you will connect to the cluster BLR102C.

In this part, we have installed the SQL Server 2008 R2 Failover Cluster, in the next part of this series, we are going to add the second node to our Failover SQL Cluster.

About these ads

About Sudeepta Ganguly

A SQL Server User... Still Learning
This entry was posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation and tagged , , . Bookmark the permalink.

2 Responses to Building a SQL Server 2008 R2 Cluster: Part VI

  1. Pingback: Building a SQL Server 2008 R2 Cluster: Part VIII | SQL…. Still Learning

  2. Pingback: Building a SQL Server 2008 R2 Cluster: Part V | SQL…. Still Learning

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