SQL 2005 Cluster Setup Checklist

SQL 2005 Cluster Setup Checklist

Rate This
  • Comments 19

 

I know there are many resources on various web sites to install SQL Server 2005 on Cluster. Below are the three documents which I always share with my customers.

Server Clusters: Storage Area Networks http://www.microsoft.com/downloads/details.aspx?FamilyID=ea283d46-125f-4f94-9059-87681c0ab587&DisplayLang=en

Guide to Creating and Configuring a Server Cluster under Windows Server 2003 http://www.microsoft.com/downloads/details.aspx?FamilyID=a5bbb021-0760-48f3-a53b-0351fc3337a1&DisplayLang=en

SQL Clustering White paper: .  http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

Another great blog by Arvind on similar topic http://blogs.msdn.com/arvindsh/archive/2009/01/03/sql-server-2000-2005-failover-cluster-pre-installation-checklist.aspx

Below is the template you should fill before stating cluster installation. These will be required through out the process of installing windows cluster and then SQL cluster. You can take printout and make hard copy for your ready reference.

Parameter

Example

Value

Domain Name

MyDomain.com

 

Node 1 Name

ClusterNode1

 

Node 2 Name

ClusterNode2

 

Node 1 Public Network IP Address/Mask

192.168.1.1/255.255.255.0

 

Node 2 Public Network IP Address/Mask

192.168.1.2/255.255.255.0

 

Private Network IP Address on Node1

10.10.10.1/255.0.0.0

 

Private Network IP Address on Node2

10.10.10.2/255.0.0.0

 

Admin Account Name and Password

Administrator/P@sswOrd101

 

Windows Cluster Virtual Name

WindowsCLUSTER

 

Windows Cluster IP Address

192.168.1.3/255.255.255.0

 

MSDTC IP Address

192.168.1.4/255.255.255.0

 

MSDTC Network Name

MSDTC

 

Virtual SQL Server Name (default or named)

SQLCLUSTER\MyInstance

 

Virtual SQL IP Address

192.168.1.5/255.255.255.0

 

Cluster Service Account Name and Password

ClusterSVC/P@sswOrd101

 

SQL Service Account Name and Password

SQL2K5SVC/P@sswOrd101

 

SQL Server Domain Group Name

SQL Server Admins

 

MSDTC Disk Letter

M:

 

Quorum Disk Letter

Q:

 

Drive letter for SQL Server database files

N, O, P

 

Any comments are most welcome.

Leave a Comment
  • Please add 7 and 6 and type the answer here:
  • Post
  • Hi Dinesh,

    There is already a support webcast on same topic.

    http://support.microsoft.com/kb/953170

    Regards,

    Balmukund

  • i think im not satisfied.can u explain the benefits of server clustering,advantages and summaries all about server clustering in SQL Server 2005.

  • That is indeed a helpful set of link old friend. The whitepaper for SQL clustering is sufficent for normal cluster installs.

  • How many IP's required to set up MSCS minimum? Some says 5 and 6. Is MSDTC IP is mandatory?

Page 2 of 2 (19 items) 12