Joel Francisco geek stories and photography misadventures

Step by Step to SQL Server 2008 Clustering

Hi, I'm sharing this document I made for a client we had. I installed SQL Server 2008 enterprise edition, clustered active/passive on their blade servers. In this installation, I have faced couple of problems and bugs, and i thank google for everything.

Without much ado, here you go....

Steps:

1. Configure MSCS or simply cluster the two servers

Cluster node 1
From cluster node 1, open Cluster Administrator by clicking on Start\All Programs\Administrative Tools\Cluster Administrator. Select Create New Cluster from the pull down menu and click OK. This will open the New Cluster wizard.

Select the cluster name (CLUSTERNAMEYOUWANT); then click next. Verify Node 1’s computer name is selected. Click Next. Cluster configuration will begin. Once cluster analysis is complete, click Next, and you will be asked to input an IP address. This is the cluster IP address that cluster management will use to connect to the cluster. Use the IP address of yourcustomipadd.  Next, enter the Cluster Service account credentials that were created in the beginning of this paper. UID = yourclusteraccount and Password = yourpassword. Click next, and cluster analysis will begin to check for validity (