Installation SQL Server 2005/2008 failover clusters on MSCS Windows 2003/2008

The installation process between SQL Server 2008 and 2005 failover clusters are different.

With SQL Server 2008 in cluster you must run the setup process for SQL Server individually on each node of the failover cluster. To add a node to an existing SQL Server failover cluster, you must run SQL Server Setup on the node that is to be added to the SQL Server failover cluster instance : 

    Step 1 : Validation wizard
    Step 2 : Pre-check
    Step 3 : Installation of the first node
    Step 4 : Add a new node
    Step 5: Apply a service pack or hotfix on a SQL cluster




Whereas with SQL Server 2005 must run the setup from the active node. Then a silence installation will be performing automatically on each node.



Windows Server 2003/2008 MSCS validation

Before run the setup SQL Server installation, you must validate the hardware configuration by using the cluster validation wizard for Windows Server 2008 and the Windows Server Catalog (http://www.windowsservercatalog.com/) to search for complete cluster solutions for previous Windows Server versions.

SQL Server 2008 failover clusters and stand-alone instances of SQL Server 2008 are not supported on Windows Server 2008 Server Core.

The Microsoft Support Policy for Windows Server 2008 Failover Clusters
http://support.microsoft.com/kb/943984

Failover Cluster Step-by-Step Guide: Validating Hardware for a Failover Cluster
http://technet.microsoft.com/en-us/library/cc732035.aspx

Clustering and High Availability
http://blogs.msdn.com/clustering/archive/2008/01/18/7151154.aspx

Recommended hotfixes for Windows Server 2003 Service Pack 2-based server clusters
http://support.microsoft.com/kb/935640  



Before the installation
Before to start the installation, I invite you to read the documentation below:

Planning a SQL Server Installation
http://msdn.microsoft.com/en-us/library/bb500442.aspx  

Before Installing Failover clustering
http://msdn.microsoft.com/en-us/library/ms189910.aspx  


Important:
1.  The nodes must share a common disk subsystem.
2.  The nodes must live on the same local area network (LAN)/subnet.*
3.  The nodes must have a network heartbeat with low latency, less the 500ms.


* Separate subnets for cluster nodes: Although Windows Server 2008 failover clusters support separate subnets for cluster nodes, SQL Server 2008 failover clusters do not.


What versions of SQL are supported on Windows 2008 Server R2?
 
•  SQL Server 2005: SP3 is the minimum requirement for all editions of SQL Server 2005 with the exception of SQL Server 2005 Express.

•  SQL Server 2008: SP1 is the minimum requirement for all editions of SQL Server 2008 with the exception of SQL Server 2008 Express
 
 
List of known issues when you install SQL Server 2005 on Windows Server 2008
http://support.microsoft.com/kb/936302/en-us  

List of known issues when you install SQL Server Windows Server 2008 R2
http://support.microsoft.com/kb/955725/en-us  

The Microsoft SQL Server support policy for Microsoft clustering
http://support.microsoft.com/kb/327518/en-us  



Start the installation

Step 1: Pre-check the system to be ready for setup procedure :

o  Stop monitoring services (MOM or equivalent)
o  Stop anti-virus services
o  Verify that Terminal service is NOT running on any cluster node. Log off all Terminal Server/Remote Sessions from all secondary nodes before you start setup for SQL 2005.
o  Ensure that Windows Cryptographic Service Provider and Task Schedule service is running on all nodes.
o  Move disk resource (on which SQL Server will be installed) from 1 node to the other just to make a test.


Step 2: Run the SQL Server setup to properly install the instance :

o  Go on the node owning the targeted cluster group.
o  Use a local copy of the setup folder. Setup files should be based on active machine

For more detail : Installation step by step of SQL Server 2008 clustering on Windows 2008

How to: Create a New SQL Server Failover Cluster
http://msdn.microsoft.com/en-us/library/ms179530.aspx

Microsoft SQL Server 2005 Failover Clustering on Windows Server 2008
http://support.microsoft.com/default.aspx?kbid=953170

Failover Cluster troubleshooting
http://msdn.microsoft.com/en-us/library/ms189117.aspx
 
Changing SQL Server parameters in a clustered environment when SQL Server is not online
http://support.microsoft.com/kb/953504/en-US
 

Step 3: Post-installation checklist

Install the latest service pack for SQL Server in the article Microsoft Support Policies regarding SQL Server: http://blogs.technet.com/mdegre/archive/2009/07/15/microsoft-support-policies.aspx
 
Move disk resource (on which SQL Server was installed) from 1 node to the other just to make a test  and Run the query below  :


Paso 3: Lista de verificación post-instalación

Instalar el último Service Pack para SQL Server en el artículo de soporte técnico de Microsoft con respecto a las políticas de SQL Server: http://blogs.technet.com/mdegre/archive/2009/07/15/microsoft-support-policies.aspx?es
 
Mover recurso de disco (en la que SQL Server se instaló) a partir del 1 de nodo a los demás para hacer una prueba y ejecutar la consulta a continuación: :


SELECT * FROM sys.dm_os_cluster_nodes
GO
SELECT * FROM sys.dm_io_cluster_shared_drives
GO
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')
GO 
SELECT    SERVERPROPERTY('IsClustered') as _1_Means_Clustered ,
  SERVERPROPERTY('Edition') as Edition , 
  SERVERPROPERTY('ProductVersion') as Version , 
  SERVERPROPERTY('ProductLevel') as versionNameWithoutHotfixes,
  SERVERPROPERTY('ResourceVersion') as 'ResourceVersion',
  SERVERPROPERTY('ResourceLastUpdateDateTime') as 'last updated'


SQL Server Failover Clustering White Paper

SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en

SQL Server 2008 Failover Clustering White Paper
http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx

Michel Degremont | Microsoft EMEA
Product Support Services Developer - SQL Server Core Engineer |


Cómo crear un nuevo clúster de conmutación por error de SQL Server (programa de instalación)
http://msdn.microsoft.com/es-es/library/ms179530.aspx

WebCast de soporte técnico: Microsoft SQL Server 2005 conmutación en Windows Server 2008
http://support.microsoft.com/kb/953170/es

Solucionar problemas de clústeres de conmutación por error
http://msdn.microsoft.com/es-es/library/ms189117.aspx
 
Cómo cambiar los parámetros de SQL Server en un entorno agrupado cuando SQL Server no está conectado
http://support.microsoft.com/kb/953504/es