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.
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:
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.
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.
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.