Share via

SQL 2005 Cluster Setup Checklist

  • Article

 

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 https://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 https://www.microsoft.com/downloads/details.aspx?FamilyID=a5bbb021-0760-48f3-a53b-0351fc3337a1&DisplayLang=en

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

Another great blog by Arvind on similar topic https://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.

Comments

  • Anonymous
    January 01, 2009
    This is not sufficent for that

  • Anonymous
    January 01, 2009
    Santosh, I could not understand the post. Can you please explain. I am all ears.

  • Anonymous
    January 09, 2009
    HiActually i need script or guide to install Multi instance clustering, As I have 3 DB Servers lets say DB1 DB2 DB3, DB1&DB2 are in Active Active cluster Which has 4 Databases A/B/C/D,hence both DB1 & DB2 will have these A/B/C/D i want to have a multi instancing cluster for database D on Server DB3how to go about it?? plz help  RegardsSantosh Dwivedi<santosh.dwivedi@astrowix.com>

  • Anonymous
    January 09, 2009
    sorry just made one mistake while expalining, DB1&DB2 are in Active Passive Cluster, wherein DB2&DB3 need to be in Active Active Cluster,plz endorse

  • Anonymous
    January 10, 2009
    Hi Santosh, thanks for writing back.Active-Active or Active-Passive are confusing term.All I understand is that you have 3 nodes in a windows cluster called DB1, DB2 and DB3. from your explaination I am failing to understand that how many SQL Instances you are talking about.There is no concept called "multi instancing cluster for database D". Windows Clustering works in shared-nothing model which means, one resource would onlt be with one node at a given point of time.If you can explain more, I will try to help you further.

  • Anonymous
    May 13, 2009
    HiCan any one tell me the Active/Active/Passive SQL 2005 Clustering, is passive node is standby or passive.

  • Anonymous
    May 13, 2009
    Well, Active/Active/Passive is confusing.How many nodes? How many SQL Instances?

  • Anonymous
    May 19, 2009
    Well, there seems to be a lot of confusion around the Active-Active / Active-Passive term. I have seen many users and customers use this term; however, this concept is not out dated and no longer in use.The term Active-Active and Active-Passive dates back to the SQL Server 7.0 days when we did not have the concept of multiple instances running on a machine or a node. We just had a default instance; and just one instance running on one machine.In the SQL Server 7.0 days, we could have just two configurations, considering a 2-Node cluster:One single default instance running on Node1 and nothing running on Node2. This is what we used to call as the Active-Passive Clustering.We could also have a default instance running on Node1 and another default instance running on Node2. This is what was termed as a Active-Active Cluster. However, I am not sure how failover used to occur those times; I have never worked with a SQL Server 7.0 Cluster. Since SQL Server 2000 came into being, we have the concept of multiple instances per machine. We can have one default instance and multiple named instances.On a SQL Server 2000/2005/2008 Cluster, however, we can have just one default instance and all the remaining instances have to be named instance. Additionaly, the instances can run on any node at any point in time; and again, as per requirement, they can be failed back and forth to any of the other nodes. So, again, considering a 2 Node cluster, we can have various configurations; I am listing below just a few of them:One single instance running on Node1. Nothing running on Node2.One instance running on Node1; one instance running on Node2. Two instances running on Node1; one instance running on Node2. Two instances running on Node1; nothing running on Node2. Two instances running on Node2; nothing running on Node1. So, ideally, we no longer have the concept of a Active-Active or Active-Passive Cluster. Just for an example, lets say, we have:One instance running on Node1; one instance running on Node2.What if the instance on Node2 was to failover to Node2. What would we call this configuration as?So, to conclude, let's no longer use the terms Active-Active or Active-Passive or any other combination of these terms. Let's just put across the same information in the form of:"I have 4 instances of SQL Server 2005 running on a 3 Node Cluster; instance I1 and I2 running on Node1, I3 running on Node2 and I4 on Node3...". That would give us a much clearer picture of your setup.Hope you agree Balmukund... :)

  • Anonymous
    May 19, 2009
    Typo in the previous comment:Please read the first paragraph as: "however, this concept is now out dated and no longer in use."

  • Anonymous
    June 17, 2009
    It is very excellent Suhas. It give some very good pic abt clustering.

  • Anonymous
    December 22, 2009
    Thanks Suhas..Ur explanation was really helpful..Gr8 work..

  • Anonymous
    January 29, 2010
    Suhas,In a configuration where you have 2 instances on Node1 and 1 instance on Node2, if Node1 fails for example, will the 2 SQL instances on that node be transfered to Node2?

  • Anonymous
    January 30, 2010
    Hi TDAji,If all three instances are "clustered" then any instance can run on any node.To answer your question, Yes. those 2 instances would be transfered to Node2 automatically.Regards,Balmukund

  • Anonymous
    January 31, 2010
    Thanks Balmukund.The reason for my previous question is to do with processor usage. The one instance that i want on Node2 is processor intensive therefore i need to know that one server is being utilised solely for that database instance.

  • Anonymous
    February 16, 2010
    Hi,I need to install a two node sql 2005 failover cluster on windows server 2008. It will be great help if I get the step-by-step guide link for installing sql2005 on windows 2008.Thanks

  • Anonymous
    February 16, 2010
    Hi Dinesh,There is already a support webcast on same topic.http://support.microsoft.com/kb/953170Regards,Balmukund

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

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

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