Sunday, June 14, 2009

Installing SQL Cluster in Windows 2008

Installation of Cluster service consists of certain stages

1- Configure Hardware(shared Storage, Heartbeat NIC)

2- Install Failover Cluster feature

3- Create Cluster Group

 

4- Add shared Hardware

5- Install SQL 2005

6- Install SQL 2005 SP2

Here below some details.

 

Install Failover Cluster through Add features

 

clip_image002

Create Cluster Group

Add shared disk to the cluster group

Add more cluster nodes

Start Installing SQL Server 2005 on one of the cluster nodes.

clip_image002[4] 

clip_image002[6]

clip_image002[8]

clip_image002[10]

clip_image002[12]

clip_image002[14]

clip_image002[16]

clip_image002[18]

clip_image002[20]

clip_image002[22]

clip_image002[24]

clip_image002[26]

clip_image002[28]

clip_image002[30]

clip_image002[32]

The installation of SQL server 2005 is now completed.

if you look at the Failover Cluster Management Snap-in, you will find that the Cluster resources( Name of the cluster and IP and the SQL services) one of these services is failed to start, this  is because compatibility issues with Windows Server 2008; the minimum supported version is SQL Server 2005 SP2, once it get installed everything will work fine.

clip_image002[34]