Windows 2008 Failover Clustering: Configuring SQL 2008 for Failover Clustering

Printable View

2010-03-02, 05:54 PM
patris1

Windows 2008 Failover Clustering: Configuring SQL 2008 for Failover Clustering

[LEFT][CODE]http://itprosecure.com/blogs/windows_2008_admnistration/archive/2009/08/03/windows-2008-failover-clustering-configuring-sql-2008-for-failover-clustering-part-1-of-3.aspx[/CODE][B][SIZE=3]
PART-1[/SIZE][/B]

Configuring Windows 2008 Failover Clustering is another mechanism we have to make Applications 'Highly Available' for End Users. Many of the 'Windows Core Infrastructure Applications' (Operations Manager 2007, Configuration Manager 2007, etc.) require a specific version of Microsoft SQL as the Core Database Engine and/or Core Reporting Services Engine to function. In this multi-part Blog entry I will review some of the configuration steps to offer SQL 2008 Services on a Windows 2008 Failover Cluster.
Here are the Blog entries that comprise the aggregate solution:
[B]Windows 2008 Failover Clustering: Configuring SQL 2008 for Failover Clustering - Part 1 of 3 [B](this Blog entry!)[/B][/B]
[B]Windows 2008 Failover Clustering: Configuring SQL 2008 for Failover Clustering - Part 2 of 3 [/B]
[B]Windows 2008 Failover Clustering: Configuring SQL 2008 for Failover Clustering - Part 3 of 3[/B]
First, I will build the Windows 2008 Failover Cluster using 3 Nodes and a Node Majority for the Quorum Configuration. Here is that completed work.
[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0057.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0057-mini.gif[/IMG][/URL]
[B]Figure A[/B] - 3 Node Windows 2008 Failover Cluster. This is built in Blog Part 1 and 2.

Then I will build the Application Cluster running Windows 2008 Failover Clustering and SQL 2008 Failover Clustering Services.
[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0013.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0013-mini.gif[/IMG][/URL]
[B]Figure B[/B] - 3 Node Windows 2008 Failover Cluster with SQL 2008 Failover Cluster across all Nodes. This is built in Blog Part 3.
***************************************************************************
***************************************************************************

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0000.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0000-small.gif[/IMG][/URL]
[B]Figure 1[/B] - I begin with 3 Nodes configured as Windows 2008 x64 Enterprise Edition Servers. These Servers are Patched through July 2009 and include the following Feature:
[I]Failover Clustering[/I]
In addition, I am using the [URL="http://www.starwindsoftware.com/starwind-server-iscsi-san"]StarWind iSCSI Server[/URL] as the iSCSI Target and the [URL="http://www.microsoft.com/downloads/details.aspx?FamilyID=12cb3c1a-15d6-4585-b385-befd1319f825&DisplayLang=en"]Microsoft iSCSI Initiator[/URL] application provided as part of the Operating System for Windows 2008.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0001.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0001-small.gif[/IMG][/URL]
[B]Figure 2[/B] - The 'Disk Management' MMC in Server Manager shows the LUNs presented over iSCSI to all three Failover Cluster Nodes. I always configure a 'Quorum Drive', even for a configuration like this (with 3 Nodes) that does not require a Quorum Drive.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0002.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0002-small.gif[/IMG][/URL]
[B]Figure 3[/B] - I get underway by using Server Manager invoking the 'Add Roles' function. It is my intention to add the 'Application Server' Role initially.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0003.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0003-small.gif[/IMG][/URL]
[B]Figure 4[/B] - The initial screen for the 'Add Roles Wizard' confirms details specific to proceeding.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0004.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0004-small.gif[/IMG][/URL]
[B]Figure 5[/B] - In the 'Add Roles Wizard' I select 'Application Server'. The paradigm of 'Application Servers' encompasses many different aspects of running an Application on the Windows 2008 Platform, and is most focused on Web Services.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0005.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0005-small.gif[/IMG][/URL]
[B]Figure 6[/B] - Upon adding the 'Application Server' Role the prerequisite 'Features' offer a Confirmation of addition of such Features. Specifically, the 'Application Server' Role requires 'Windows Process Activation'.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0006.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0006-small.gif[/IMG][/URL]
[B]Figure 7[/B] - After confirmation of the Features required by the Application Server Role the 'Add Roles Wizard' offers validation of the scope of Services provided by adding the 'Application Server' Role.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0007.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0007-small.gif[/IMG][/URL]
[B]Figure 8[/B] - One of the primary reasons for adding the 'Application Server' Role is addition of 'Data Transformation Services'. Here, I confirm addition of both 'Incoming Remote Transactions' and 'Outgoing Remote Transactions'.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0008.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0008-small.gif[/IMG][/URL]
[B]Figure 9[/B] - Upon confirmation of both the Role and Features I am ready to 'Install' to proceed.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0009.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0009-small.gif[/IMG][/URL]
[B]Figure 10[/B] - Installation successful! Next I will proceed to confirm the COM+ Application configuration.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0010.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0010-small.gif[/IMG][/URL]
[B]Figure 11[/B] - Here I review the COM+ Application configuration resulting from the choices for both 'Role' and 'Features' for the 'Application Server' Role.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0011.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0011-small.gif[/IMG][/URL]
[B]Figure 12[/B] - Previously, I installed the 'Feature' of 'Failover Clustering' that includes the 'Failover Clustering Tools'. This occurred while configuring the iSCI Initiator and iSCSI Target parameters.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0012.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0012-small.gif[/IMG][/URL]
[B]Figure 13[/B] - Upon opening the 'Failover Clustering Management' MMC, the recommended approach is to select 'Validate a Configuration (Cluster Configuration)' from the 'Management' leaf of the MMC.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0013.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0013-small.gif[/IMG][/URL]
[B]Figure 14[/B] - The 'Validate a Configuration Wizard' presents relevant information on proceeding through the Validation Process.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0014.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0014-small.gif[/IMG][/URL]
[B]Figure 15[/B] - In the next step of the 'Validate a Configuration Wizard' I input the Host by Name (b01-node-1.corp.itpslab.local) and proceed to confirmation Test Parameters.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0015.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0015-small.gif[/IMG][/URL]
[B]Figure 16[/B] - The default value of 'Run All Tests' is reasonable seeing this is the first Node in a multi-Node Cluster Configuration.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0016.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0016-small.gif[/IMG][/URL]
[B]Figure 17[/B] - Selecting 'Run All Tests' provides a Summary of both Servers (Nodes) targeted for Testing and the Test List.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0017.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0017-small.gif[/IMG][/URL]
[B]Figure 18[/B] - Upon completion of the 'Validate a Configuration Wizard' Summary Information is provided in both condensed and detailed format. The detailed format is available by selecting 'View Report' from the Summary screen.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0018.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0018-small.gif[/IMG][/URL]
[B]Figure 19[/B] - Upon review of the 'Validate a Configuration Wizard' Summary Report, and in observing no Critical Errors I proceed to 'Create a Cluster' using the 'Create a Cluster' Wizard.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0019.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0019-small.gif[/IMG][/URL]
[B]Figure 20[/B] - The initial information from the 'Create a Cluster Wizard' introduces details pertinent to Cluster Creation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0020.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0020-small.gif[/IMG][/URL]
[B]Figure 21[/B] - This is the first Node and as such I simply add 'bo1-node-1.corp.itpslab.local' to the 'Selected Servers' list.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0022.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0022-small.gif[/IMG][/URL]
[B]Figure 22[/B] - In a step not show here I add 'app-cluster-01' as the 'Cluster Name' (Cluster Name Object, or CNO). Additionally, I assign the CNO an IP Address of 192.168.1.65 from the IP Schema for the 'Public Network'. The 'Create a Cluster Wizard' confirms the ability to proceed to completion in creating a single Node Cluster on Windows 2008.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0024.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0024-small.gif[/IMG][/URL]
[B]Figure 23[/B] - The 'Create Cluster' Report provides Summary Detail on the Cluster Creation process for further review.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0025.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0025-small.gif[/IMG][/URL]
[B]Figure 24[/B] - The additional relevant Detail from the 'Create a Cluster' Summary Report.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0026.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0026-small.gif[/IMG][/URL]
[B]Figure 25[/B] - Moving back to the 'Failover Cluster Management' MMC we observe several details about this Cluster Configuration. Node 'b01-node-1.corp.itpslab.local' includes a Single Node, the Quorum Configuration is 'Node Majority', and 2 Separate IP Networks provide Services for this Cluster Configuration.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0027.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0027-small.gif[/IMG][/URL]
[B]Figure 26[/B] - Selecting 'Storage' from the 'Failover Cluster Management' MMC indicates 'No Storage' selected for the Cluster Configuration. I can easily 'Add a Disk' using the 'Action Menu' or by 'Right Mouse Clicking' the 'Storage' leaf.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0028.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0028-small.gif[/IMG][/URL]
[B]Figure 27[/B] - Selection of 'Cluster Network 1 (the Default Name given)' indicates this is the IP Interface for the 'Public Network' for this configuration. The 'Public Network' provides Client Connectivity Traffic to/from the Cluster Node.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0029.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0029-small.gif[/IMG][/URL]
[B]Figure 28[/B] - The 'Private Network' handles the 'Heartbeat Traffic' between Cluster Nodes.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0030.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0030-small.gif[/IMG][/URL]
[B]Figure 29[/B] - Next, I move to Node 2 to add the Failover Cluster Services to the Cluster title 'app-cluster-01.corp.itpslab.local'. This second Node is configured exactly like the first Node.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0031.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0031-small.gif[/IMG][/URL]
[B]Figure 30[/B] - I begin with the 'Validate a Configuration Wizard' as previously completed on Node 1.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0032.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0032-small.gif[/IMG][/URL]
[B]Figure 31[/B] - Once initiated, the 'Validate a Configuration Wizard' provides the detail required to add the second Node to this Failover Cluster configuration.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0033.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0033-small.gif[/IMG][/URL]
[B]Figure 32[/B] - I add the current Cluster Node (bo1-node-1) and the targeted Cluster Node (b01-node-2) to this process of Validation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0034.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0034-small.gif[/IMG][/URL]
[B]Figure 33[/B] - I select 'Run All Tests' and initiate the Validation process.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0035.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0035-small.gif[/IMG][/URL]
[B]Figure 34[/B] - Here is the Summary of 'Servers to Test' and 'Test Selected by the User' for the 'Validate a Configuration Wizard'. Output of these Tests will confirm/deny the ability to add a second Node to the Cluster.

[COLOR=#008000][/COLOR]
[/LEFT]
2010-03-02, 05:56 PM
patris1

[LEFT][B][SIZE=3]PART-1[/SIZE][/B]

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0036.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0036-small.gif[/IMG][/URL]
[B]Figure 35[/B] - This screen capture is 'mid process' to show some of the many processes for Validation that occurs. This process titled 'Validate Multiple Arbitrators' is focused on Disk Arbitration for the Cluster Node.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0037.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0037-small.gif[/IMG][/URL]
[B]Figure 36[/B] - Upon successful completion of the 'Validate a Configuration Wizard' I select 'View Report' to see the Validation detail.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-00038.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0038-small.gif[/IMG][/URL]
[B]Figure 37[/B] - Since Cluster Node 2 (b01-node-2) was Validated correctly I decide to bring both Cluster Node 2 and Cluster Node 3 'into the Cluster' simultaneously. Of course, for Cluster Node 3 that means passing the 'Validate a Configuration Wizard' will be run through successful completion. I am confident, as all three Cluster Nodes are configured exactly the same!

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0040.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0040-small.gif[/IMG][/URL]
[B]Figure 38[/B] - Same process for running the 'Validate a Configuration Wizard' as seen in the two prior examples.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-00041.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0041-small.gif[/IMG][/URL]
[B]Figure 39[/B] - I add all three Cluster Nodes (2 'prospective Cluster Nodes') for Validation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0042.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0042-small.gif[/IMG][/URL]
[B]Figure 40[/B] - Again, I select 'Run All Tests' for this Validation process.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0043.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0043-small.gif[/IMG][/URL]
[B]Figure 41[/B] - Upon selecting 'Run All Tests' I observe the 'Servers to Tests' and 'Tests Selected by the User'.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0044.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0044-small.gif[/IMG][/URL]
[B]Figure 42[/B] - All three Cluster Nodes pass the Validation Tests. I am now ready to add both Cluster Node 2 (b01-node-2) and Cluster Node 3 (b01-node-3) to the Failover Cluster Configuration.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0045.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0045-small.gif[/IMG][/URL]
[B]Figure 43[/B] - Moving back to Cluster Node 2 (b01-node-2.corp.itpslab.local) I will begin the 'Add a Node' process using the 'Failover Cluster Manager' MMC.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0046.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0046-small.gif[/IMG][/URL]
[B]Figure 44[/B] - I select 'Manage a Cluster', which provides the ability to 'Add a Node' to an existing Cluster (app-cluster-01.corp.itpslab.local).

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0048.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0048-small.gif[/IMG][/URL]
[B]Figure 45[/B] - Once focused upon the Cluster (app-cluster-01.corp.itpslab.local) I use the 'Actions' Pane and select 'Add Node'.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0049.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0049-small.gif[/IMG][/URL]
[B]Figure 46[/B] - The 'Add a Node Wizard' will allow adding more than one Node simultaneously.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0050.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0050-small.gif[/IMG][/URL]
[B]Figure 47[/B] - I add Cluster Node 2 and Cluster Node 3 (b01-node-2 and b01-node-3) simultaneously.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0051.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0051-small.gif[/IMG][/URL]
[B]Figure 48[/B] - Upon selecting 'Next' I am presented with the addition of the Cluster Nodes.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0052.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0052-small.gif[/IMG][/URL]
[B]Figure 49[/B] - The Cluster Nodes were added successfully with a concise Report available for review.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0053.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0053-small.gif[/IMG][/URL]
[B]Figure 50[/B] - The 'Add Cluster Nodes' Report summarized all Actions that comprise the Cluster Node addition.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0054.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0054-small.gif[/IMG][/URL]
[B]Figure 51[/B] - Here is the second of three pages of the 'Add Cluster Nodes' Report.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0055.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0055-small.gif[/IMG][/URL]
[B]Figure 52[/B] - Here is the third of three pages of the 'Add Cluster Nodes' Report.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0056.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0056-small.gif[/IMG][/URL]
[B]Figure 53[/B] - Using the 'Failover Cluster Management' MMC I focus on observing the 3 Nodes of this Cluster. The 'Storage' leaf provides summarized detail of Storage specific to 'Total Capacity' and 'Available Capacity'.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0057.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0057-small.gif[/IMG][/URL]
[B]Figure 54[/B] - Selecting the 'Node' leaf and highlighting 'b01-node-1' I observe the 'Resources' associated with that Node. All available LUNs (Disk Drives) are 'Online' and waiting 'matching' with an Application.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0058.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0058-small.gif[/IMG][/URL]
[B]Figure 55[/B] - Upon moving to highlight 'b01-node-2' note that no Disk Resources are controlled by this Cluster Node.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0059.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0059-small.gif[/IMG][/URL]
[B]Figure 56[/B] - A similar observation can be made when highlighting 'b01-node-3' regarding Disk Resources.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0060.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0060-small.gif[/IMG][/URL]
[B]Figure 57[/B] - I select 'Services and Applications' where there are currently no Services or Applications defined. We are preparing this Failover Cluster to accept SQL 2008 Failover Clustering Services.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0061.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0061-small.gif[/IMG][/URL]
[B]Figure 58[/B] - Note that selection of the Cluster Name Object (CNO) there is 'Summary Information' regarding the Cluster. Here, I focus on the 'Quorum Configuration' which is 'Node Majority'. Node Majority is appropriate for a 3 Node Cluster per the defined Quorum Model requirements.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0062.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0062-small.gif[/IMG][/URL]
[B]Figure 59[/B] - Selection of the Cluster Name Object and then 'Configure Cluster Quorum Wizard' invokes the possible Quorum Configuration types acceptable to a Windows 2008 Failover Cluster. The Wizard selects the 'most suitable' Quorum Configuration based upon Disk, Node and Network Configuration criteria.
[COLOR=#008000][B]Summary:[/B] In this Blog entry, the first of three, I follow step-by-step procedures to 1) Validate a 3 Node Cluster Configuration, and 2) Create a 3 Node Cluster Configuration using Windows 2008 Failover Clustering. The 3 Node Cluster will be used to Install and Configure SQL 2008 Failover Clustering Services[/COLOR]
[/LEFT]
2010-03-02, 05:57 PM
patris1

[LEFT][CODE]http://itprosecure.com/blogs/windows_2008_admnistration/archive/2009/08/03/windows-2008-failover-clustering-configuring-sql-2008-for-failover-clustering-part-2-of-3.aspx[/CODE]

[B][SIZE=3]PART-2[/SIZE][/B]

First, I will build the Windows 2008 Failover Cluster using 3 Nodes and a Node Majority for the Quorum Configuration. Here is that completed work.
[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0057.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0057-mini.gif[/IMG][/URL]
[B]Figure A[/B] - 3 Node Windows 2008 Failover Cluster. This is built in Blog Part 1 and 2.

Then I will build the Application Cluster running Windows 2008 Failover Clustering and SQL 2008 Failover Clustering Services.
[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0013.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0013-mini.gif[/IMG][/URL]
[B]Figure B[/B] - 3 Node Windows 2008 Failover Cluster with SQL 2008 Failover Cluster across all Nodes. This is built in Blog Part 3.
***************************************************************************
***************************************************************************

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0000.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0000-small.gif[/IMG][/URL]
[B]Figure 1[/B] - Now that a 3 Node Failover Cluster is available on Windows 2008 I begin to evaluate if the configuration is suitable to support Failover, moving Nodes Offline (for Patching) and if the Cluster is ready for the next step of Installing Clustered DTS Services in advance of SQL 2008 Failover Services. I begin by Logging on in a User Context of a Domain User who is Local Administrator and 'Full Cluster Administrator' (cluster-os-install-admin-1).

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0001.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0001-small.gif[/IMG][/URL]
[B]Figure 2[/B] - I select the 'Failover Cluster Management' MMC and observe the 'Current Host Server' is 'b01-node-1', or, Node 1 of 3 in our Cluster (app-cluster-01.corp.itpslab.local). The Quorum Configuration is 'Node Majority' which is appropriate for a 3 Node Cluster.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0002.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0002-small.gif[/IMG][/URL]
[B]Figure 3[/B] - Selecting the 'Node' leaf and highlighting Node 1 (b01-node-1) I observe the Disk and Network Resources 'matched' to this Cluster Node. It is my intention to 'Move' these Resources (the Disk specifically) to another Cluster Node. I will complete this using an Administrative Command Prompt.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0003.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0003-small.gif[/IMG][/URL]
[B]Figure 4[/B] - I invoke a Command Prompt from the 'Quick Launch Bar' where many of the most frequently used Application Short Cuts are placed. Upon selecting the 'Command Prompt', I then select 'Run As Administrator' and 'Accept' the User Account Control popup.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0004.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0004-small.gif[/IMG][/URL]
[B]Figure 5[/B] - In an 'Administrative Command Prompt' I issue the 'cluster group' Command to identify Cluster Groups by Name and the associated Node controlling those Groups and Resources. Notice the 'Status' is readily available confirming the Health of our Cluster Nodes.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0005.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0005-small.gif[/IMG][/URL]
[B]Figure 6[/B] - Next, I issue the 'cluster group "available storage" /move:b01-node2', and, 'cluster group "cluster group" /move:b01-node-2" Commands (respectively). These 2 Commands move the 'Available Storage' and 'Cluster Group' from Node 1(b01-node-1) to Node 2(b01-node-2).

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0006.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0006-small.gif[/IMG][/URL]
[B]Figure 7[/B] - Now, issuing the 'cluster group' Command a second time confirms 'movement' from Node 1 to Node 2 of these Cluster Groups. This is a good sign the Cluster is functioning correctly.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0007.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0007-small.gif[/IMG][/URL]
[B]Figure 8[/B] - Using the 'Failover Cluster Management' MMC and selecting 'b01-node-1' in the 'Nodes' leaf I notice the provisioned LUNs (Disk Drives) no longer appear 'associated' with Node 1 (b01-node-1). They should appropriately appear 'associated' with Node 2 (b01-node-2).

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0008.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0008-small.gif[/IMG][/URL]
[B]Figure 9[/B] - Success! The LUNs appear associated with Cluster Node 2 (b01-node-2) after being moved using the 'cluster.exe' Command Line parameters. This same type of endeavor will be completed to move Resources and Groups to Cluster Node 3 (b01-node-3).

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0009.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0009-small.gif[/IMG][/URL]
[B]Figure 10[/B] - In the 'Failover Cluster Management' MMC we observe the 'Current Host Server' to be 'b01-node-2' (instead of 'b01-node-1' as prior to the Commands to 'Move' Groups). This visual feedback confirms capability to move 'Groups' between Nodes.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0010.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0010-small.gif[/IMG][/URL]
[B]Figure 11[/B] - In a change of focus of the 'Failover Cluster Management' MMC with a selection of the 'Services and Applications' leaf it is evident that no 'Service or Application' has been configured for this Application Cluster. In preparation for a SQL 2008 Failover Cluster Installation, I will move to a Windows 2008 Domain Controller to generate the appropriate User IDs and Domain Global Security Groups (DGSGs).

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0011.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0011-small.gif[/IMG][/URL]
[B]Figure 12[/B] - I move next to Login to a Windows 2008 Active Directory Domain Controller. This Virtualized Lab Configuration has both the Forest and Domain Functional Levels at 'Windows 2008'. The User Context is a 'Domain Admin'.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0012.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0012-small.gif[/IMG][/URL]
[B]Figure 13[/B] - The Host Name for this Windows 2008 Domain Controller is 'b01-dc01'. I will create a list of User IDs and DGSGs for consumption by SQL 2008 Failover Clustering.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0013.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0013-small.gif[/IMG][/URL]
[B]Figure 14[/B] - In the Organizational Unit (OU) titled 'Application Failover Cluster' I generated several User IDs and a DGSG. Here is the summary list:

[LIST=1][*][COLOR=#0000FF]app-db-01 SQL Full Admins[/COLOR] - Role is a 'Full Administrator' of the SQL 2008 Database.[*][COLOR=#0000FF]app-db-01-sql-agent[/COLOR] - Role is 'Service Admin' for the SQL 2008 SQL Agent Service on the Cluster.[*][COLOR=#0000FF]app-db-01-sql-db[/COLOR] - Role is 'Service Admin' for the SQL 2008 Database Service on the Cluster.[*][COLOR=#0000FF]app-db-01-sql-rs[/COLOR] - Role is 'Service Admin' for the SQL 2008 Reporting Services Service on the Cluster.[/LIST]

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0014.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0014-small.gif[/IMG][/URL]
[B]Figure 15[/B] - Next, I create one additional Domain User titled 'sql_admin_1' which I add as a 'Member' of the 'app-db-01 SQL Full Admins' DGSG.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0015.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0015-small.gif[/IMG][/URL]
[B]Figure 16[/B] - I then move back to Cluster Node 1 (b01-node-1) to initiate the Installation of Data Transformation Services. I login as 'cluster-os-install-admin-1' who is a Local Administrator and 'Full Cluster Admin'.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0016.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0016-small.gif[/IMG][/URL]
[B]Figure 17[/B] - Installation of a Clustered DTS Service occurs by selecting 'Configure a Service or Application' from the 'Failover Cluster Management' MMC.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0017.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0017-small.gif[/IMG][/URL]
[B]Figure 18[/B] - The 'High Availability Wizard' begins to allow selection of a list of 'pre-defined Cluster Aware Services'. Clustered DTS is among the list of available Services for Clustering on Windows 2008.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0018.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0018-small.gif[/IMG][/URL]
[B]Figure 19[/B] - I select 'Distributed Transaction Coordinator (DTC)' from the list of Services and begin the Installation process.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0019.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0019-small.gif[/IMG][/URL]
[B]Figure 20[/B] - By default the 'Client Access Point' for DTC is 'app-cluster-dtc'. I select the default value and provide a unique IP Address of '192.168.1.66' for the Clustered DTS Service.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0020.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0020-small.gif[/IMG][/URL]
[B]Figure 21[/B] - In the 'LUN Provisioning Process' I identified the requirement for a small, dedicated LUN for the Clustered DTS Service. I use the 'G:\' Drive for placement of the DTC Database.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0021.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0021-small.gif[/IMG][/URL]
[B]Figure 22[/B] - Upon acceptance of the basic criteria for the Clustered DTC Service I proceed with the installation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0022.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0022-small.gif[/IMG][/URL]
[B]Figure 23[/B] - A successful installation of a Clustered DTC Service follows, including access to a Summary Report from the 'View Report' button on the 'High Availability Wizard' dialogue window.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0023.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0023-small.gif[/IMG][/URL]
[B]Figure 24[/B] - Analysis of the 'Distributed Transaction Coordinator (DTC)' Summary Report outlines the steps followed to Cluster DTC Services on Windows 2008.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0024.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0024-small.gif[/IMG][/URL]
[B]Figure 25[/B] - The 'Failover Cluster Management' MMC now offers the Clustered DTC Service as part of the 'Services and Applications' in this Failover Cluster configuration. Note the dedicated 'IP Address' (192.168.1.66) and dedicated LUN (Disk Drive - G:\). We are moving closer to the SQL 2008 Failover Cluster Installation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0025.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0025-small.gif[/IMG][/URL]
[B]Figure 26[/B] - Use of an 'Administrative Command Prompt' while issuing the 'cluster group' Command yields details regarding the 'app-cluster-dtc' Group associated with Node 2 of the Cluster (b01-node-2).

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0026.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_A-0026-small.gif[/IMG][/URL]
Figure 27 - Use of the 'cluster res' Command offers details on the 'Resources' associated with the Clustered DTC Service. We have met our objective to prepare a Windows 2008 Failover Cluster with appropriate configuration parameters to permit installation of SQL 2008 Failover Cluster Services.
[COLOR=#008000][/COLOR]
[COLOR=#008000][B]Summary:[/B] In this Blog entry, the second of three, I follow step-by-step procedures to 1) Validate Failover of a 3 Node Cluster Configuration, and 2) Installation of a Clustered DTS Service in preparation for the SQL 2008 Failover Configuration. The 3 Node Cluster will be used to Install and Configure SQL 2008 Failover Clustering Services[/COLOR]
[/LEFT]
2010-03-02, 05:58 PM
patris1

[LEFT][CODE]http://itprosecure.com/blogs/windows_2008_admnistration/archive/2009/08/03/windows-2008-failover-clustering-configuring-sql-2008-for-failover-clustering-part-3-of-3.aspx[/CODE]
[SIZE=3][B]
PART-3[/B][/SIZE]

First, I will build the Windows 2008 Failover Cluster using 3 Nodes and a Node Majority for the Quorum Configuration. Here is that completed work.
[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0057.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1-0057-mini.gif[/IMG][/URL]
[B]Figure A[/B] - 3 Node Windows 2008 Failover Cluster. This is built in Blog Part 1 and 2.

Then I will build the Application Cluster running Windows 2008 Failover Clustering and SQL 2008 Failover Clustering Services.
[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0013.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0013-mini.gif[/IMG][/URL]
[B]Figure B[/B] - 3 Node Windows 2008 Failover Cluster with SQL 2008 Failover Cluster across all Nodes. This is built in Blog Part 3.
***************************************************************************
***************************************************************************

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0000.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0000-small.gif[/IMG][/URL]
[B]Figure 1[/B] - As I get underway to install the SQL 2008 Failover Clustering configuration on the first Cluster Node (b01-node-1) I validate the available LUNs for Storage. There are 3 each 40GB LUNs (Drive L:\, M:\, N:\) with 1 each 1.4GB LUN set aside for a Quorum Drive (Q:\). We will target the SQL 2008 Services to the L:\, M:\ and N:\ Drive.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0001.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0001-small.gif[/IMG][/URL]
[B]Figure 2[/B] - I begin the SQL 2008 Failover Cluster Installation using the SQL 2008 x64 Enterprise Edition Media and selecting 'System Configuration Checker' to validate I did not overlook any additional requirements for Installation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0002.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0002-small.gif[/IMG][/URL]
[B]Figure 3[/B] - The 'System Configuration Checker' provides feedback that 14 of 14 Operations completed successfully. I proceed with the Installation Steps.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0003.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0003-small.gif[/IMG][/URL]
[B]Figure 4[/B] - I select 'Installation' from the 'SQL Server Installation Center' and then, 'New SQL Server Failover Cluster Installation'.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0004.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0004-small.gif[/IMG][/URL]
[B]Figure 5[/B] - The 'SQL Server 2008 Setup Support Rules' indicate passing on 6 of 6 Rules evaluated as part of proceeding with Installation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0005.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0005-small.gif[/IMG][/URL]
[B]Figure 6[/B] - Advancement to Acceptance of a Product Key indicates forward progress.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0006.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0006-small.gif[/IMG][/URL]
[B]Figure 7[/B] - In the 'License Terms' dialogue windows I mark the Check Box to 'Accept the License Terms' to proceed with the Installation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0007.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0007-small.gif[/IMG][/URL]
[B]Figure 8[/B] - The 'Setup Support Files' status simply requires pressing the 'Install Button' to proceed.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0008.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0008-small.gif[/IMG][/URL]
[B]Figure 9[/B] - An additional list from the 'Setup Support Rules' indicates passing on 28 Operations with Warning received on 2 Operations. Research of the 2 Operations offering Warning indicate acceptability to proceed with the Installation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0009.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0009-small.gif[/IMG][/URL]
[B]Figure 10[/B] - I double check the 2 'Operations' offering 'Warnings'. The 'Network Binding Order' and 'Windows Firewall' require additional research to confirm the specifics the 'Operation' requires. I double-checked the 'Network Binding Order' to confirm it is correct, while the 'Windows Firewall' is offering a 'Warning' simply due to a Group Policy Object 'Disabling' the Windows Firewall for the Cluster Nodes.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0011.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0011-small.gif[/IMG][/URL]
[B]Figure 11[/B] - I proceed past the 'Setup Support Rules' dialogue window and begin selecting parameters for the SQL 2008 Failover Clustering Services.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0012.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0012-small.gif[/IMG][/URL]
[B]Figure 12[/B] - In the 'Feature Selection' window for 'Install a SQL Server Failover Cluster' I select a number of 'Features'. The requirements for your Application will define the 'Features' required. Keep in mind there are special configuration steps for Features which do not Cluster, like Reporting Services.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0013.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0013-small.gif[/IMG][/URL]
[B]Figure 13[/B] - In the 'Instance Configuration' dialogue windows I input 'app-db-01' as the 'SQL Server Network Name' to proceed.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0014.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0014-small.gif[/IMG][/URL]
[B]Figure 14[/B] - In the 'Disk Space Requirements' dialogue window is the Summary of the Installation Requirements configured so far. I proceed to define the 'Cluster Resource Group' parameters next.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0015.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0015-small.gif[/IMG][/URL]
[B]Figure 15[/B] - SQL 2008 'identifies' the 'Resource Group Names' currently associated with the Cluster (these are, 'app-cluster-dtc', 'Available Storage' and 'Cluster Group'). The default name of 'SQL Server (MSSQLSSERVER)' is offered as a Resource Group Name for Clustered SQL 2008. I accept this default value and proceed.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0016.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0016-small.gif[/IMG][/URL]
[B]Figure 16[/B] - The 'Install a SQL Server Failover Cluster Wizard' advances to the 'Cluster Disk Selection' dialogue window. The Wizard defaults to the uppermost Disk available (in this case, L:\) where I add both M:\ and N:\ as well.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0017.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0017-small.gif[/IMG][/URL]
[B]Figure 17[/B] - The values for 'Cluster Network Configuration' default to 'IPv4' and 'DHCP'. I modified the default values by 'toggling off' DHCP and inputting an 'Address' and 'Subnet Mask' of '192.168.1.67' and '255.255.255.0'.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0019.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0019-small.gif[/IMG][/URL]
[B]Figure 18[/B] - In Part 2 of this Blog entry we created a number of Domain User IDs to consumption by SQL 2008. On the 'Service Accounts' Tab of the 'Server Configuration' dialogue window I input these unique User IDs for 1) SQL Server Agent, 2) SQL Server Database Engine, and 3) SQL Server Reporting Services.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0020.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0020-small.gif[/IMG][/URL]
[B]Figure 19[/B] - The 'Database Engine Configuration' dialogue window provides the ability to define 'SQL Server Administrators'. The DGSG added earlier to Active Directory titled 'app-db-01 SQL Full Admins' is 'Added' as a SQL Server Administrator.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0021.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0021-small.gif[/IMG][/URL]
[B]Figure 20[/B] - Next, I configure the 'Database Engine Configuration' by associating the appropriate Directory with a unique LUN (Disk Drive).

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0022.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0022-small.gif[/IMG][/URL]
[B]Figure 21[/B] - The 'Reporting Services Configuration' dialogue window only offers the option to 'Install, but do not configure the report server' for a Clustered Configuration. Additional details regarding Reporting Service on a SQL 2008 Failover Cluster can be identified in the MSDN Documentation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0023.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0023-small.gif[/IMG][/URL]
[B]Figure 22[/B] - The 'Error and Usage Reporting' dialogue window offers an automated capacity to provide information to Microsoft for Product improvements.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0024.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0024-small.gif[/IMG][/URL]
[B]Figure 23[/B] - The 'Cluster Installation Rules' validate passing 7 of 8 Operations with 1 of 8 being 'Not Applicable'. This steps takes us to the corner of the initial Installation of SQL 2008 Failover Clustering on a Windows 2008 Failover Cluster.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0025.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0025-small.gif[/IMG][/URL]
[B]Figure 24[/B] - The 'Ready to Install' dialogue window provides an important output file - the 'Configurationfile.ini', that records this configuration parameters. This .ini File can be used as the 'template' for Node 2 and Node 3 if appropriate.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0026.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_B-0026-small.gif[/IMG][/URL]
[B]Figure 25[/B] - Upon successful Installation the 'Install a SQL Server Failover Cluster Wizard' will provide a detailed output Text file regarding the Installation Process, Parameters and Actions. I am now ready to move from Node 1 (b01-node-1) to Node 2 (b01-node-2) for the SQL 2008 Failover Cluster Installation. The modified version of these steps occurs on Node 2 and Node 3 to ensure participation in the SQl 2008 Failover Cluster Installation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0000.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0000-small.gif[/IMG][/URL]
[B]Figure 26[/B] - Upon moving to Node 2 (b01-node-2) I initiate the SQL 2008 Failover Cluster Installation process. Again, this is a modified (i.e. reduced number of steps) version of the previous SQL 2008 Failover Cluster Installation.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0001.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0001-small.gif[/IMG][/URL]
[B]Figure 27[/B] - Instead of selecting 'New SQL Server Failover Cluster Installation' from the 'SQL Server Installation Center', I select 'Add a Node to a SQL Server Failover Cluster' instead.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0002.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0002-small.gif[/IMG][/URL]
[B]Figure 28[/B] - The 'SQL Server 2008 Setup' understand the available Cluster Groups and Cluster Resources as the Installation process begins. The 6 Operations performed for the 'Setup Support Rules' pass with Success.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0003.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0003-small.gif[/IMG][/URL]
[B]Figure 29[/B] - Notice the immediate advancement all the way to the 'Product Key' dialogue window when adding a second SQL 2008 Failover Cluster Node. In the initial SQL 2008 Failover Cluster Node Installation, this step is quite a few screens into the Installation process.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0004.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0004-small.gif[/IMG][/URL]
[B]Figure 30[/B] - Acceptance of the 'License Terms' occurs next in the 'SQL Server 2008 Setup Wizard'. I 'Accept' and proceed.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0005.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0005-small.gif[/IMG][/URL]
[B]Figure 31[/B] - The 'Setup Support Files' dialogue windows requires input of the 'Install Button' to proceed.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0006.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0006-small.gif[/IMG][/URL]
[B]Figure 32[/B] - The additional 'Setup Support Rules' triggered as part of this Installation process identify the same 2 'Warnings' (Network Binding Order and Windows Firewall) as the initial SQL 2008 Failover Cluster Node Installation. I proceed with the Installation understanding further research is required for both of these 'Warnings'.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0007.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0007-small.gif[/IMG][/URL]
[B]Figure 33[/B] - In the 'Cluster Node Configuration' dialogue windows the SQL 2008 Failover Cluster Installation 'associates' with the existing SQL Instance of 'MSSQLSERVER' on 'app-db-01'. I proceed to confirm additional of another Node to support this Instance.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0008.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0008-small.gif[/IMG][/URL]
[B]Figure 34[/B] - Input of Passwords for the 'Service Accounts' for the specific SQL 2008 Failover Cluster Services provides validation of this Node to the Cluster to run SQL Failover Cluster Services.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0009.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0009-small.gif[/IMG][/URL]
[B]Figure 35[/B] - The 'Error and Usage Reporting' dialogue window provides the options for automating Feedback to Microsoft regarding SQL 2008.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0010.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0010-small.gif[/IMG][/URL]
[B]Figure 36[/B] - The 'Add Node Rules' perform some of the final 'confirmations' prior to adding another Node to this SQL 2008 Failover Cluster configuration. I am working here on Node 2, but the exact same steps apply to the addition of Node 3.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0011.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0011-small.gif[/IMG][/URL]
[B]Figure 37[/B] - The 'Ready to Add Node' dialogue windows again points us to the 'ConfigurationFile.ini' and the beginning of the Installation process.

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0012.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0012-small.gif[/IMG][/URL]
[B]Figure 38[/B] - Here is a successful completion of adding another Node running SQL 2008 Failover Cluster Services to a Windows 2008 Failover Cluster. This process is repeated for Node 3 in this configuration following the exact same steps as outlined in this Blog entry (Part 3 of 3). The result, a 3 Node SQL Failover Cluster ready for further configuration by Application type!

[URL="http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0013.gif"][IMG]http://itprosecure.com/filestorage/CommunityServer.Components.SiteFiles/configs/win2k8_failover_sql2k8/itps_failover_cluster_install_1_C-0013-small.gif[/IMG][/URL]
[B]Figure 39[/B] - Finally, let's examine the output of following the numerous configuration steps for this environment. The 'Failover Cluster Management' MMC shows a new Application Server named 'app-db-01.corp.itpslab.local', with 3 Volumes (LUNs) supporting its Sevices (L:\, M:\ and N:\) supported across 3 Windows 2008 Failover Cluster Nodes (b01-node-1, b01-node-2 and b01-node-3). A separate Clustered Distributed Transaction Coordinate (DTC) also is available as part of this configuration.
[COLOR=#008000][B]Summary:[/B] In this Blog entry, the third of three, I follow step-by-step procedures to SQL 2008 Failover Clustering Services. This 3 Node Cluster running on Windows 2008 Failover Clustering is an example of a configuration designed to support 'Cluster Aware Applications' on Windows 2008[/COLOR]
[/LEFT]