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 6 and 4 and type the answer here:
  • Post
  • This is not sufficent for that

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

  • Hi

    Actually 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 DB3

    how to go about it?? plz help  

    Regards

    Santosh Dwivedi

    <santosh.dwivedi@astrowix.com>

  • 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

  • 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.

  • Hi

    Can any one tell me the Active/Active/Passive SQL 2005 Clustering, is passive node is standby or passive.

  • Well, Active/Active/Passive is confusing.

    How many nodes? How many SQL Instances?

  • 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:

    1. One single default instance running on Node1 and nothing running on Node2. This is what we used to call as the Active-Passive Clustering.

    2. 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:

    1. One single instance running on Node1. Nothing running on Node2.

    2. One instance running on Node1; one instance running on Node2.

    3. Two instances running on Node1; one instance running on Node2.

    4. Two instances running on Node1; nothing running on Node2.

    5. 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... :)

  • Typo in the previous comment:

    Please read the first paragraph as: "however, this concept is ***now*** out dated and no longer in use."

  • It is very excellent Suhas. It give some very good pic abt clustering.

  • Thanks Suhas..Ur explanation was really helpful..Gr8 work..

  • 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?

  • 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

  • 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.

  • 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

Page 1 of 2 (19 items) 12