I'm new to SQL and clustering...
Running cms 2002 sp2 with one SQL 2000 server backend and would like to ad a
passive SQL instance but how is that done ? (is there a HOW to outthere ?)

I have an existing 2-node cluster on older hardware that is hosting 3
SQL2000 virtual server/named instances. The current OS version for both
nodes is Windows 2003 Ent SP1.
I intend on upgrading this to a 3-node cluster by adding two very new

I have a challenge!!!!!!!!!!!
Requirements are:
A.    To replace the 2 nodes of SQL 2005 Cluster on Windows 2003 SP1, with a
set of 2 new nodes (hardware).

I know this has been talked about again, and again.. but
   This is what i got..
       1. 2x Windows 2003 Ent servers.. attached to a dell powervault 220s
storage array that has

i had to put in a long cross over cable for the private connection when i
created the cluster and now that i have a new shorter cable i was wondering
what would happen if i just replaced the cable while the system was live.
will this break things or is it safe?

I have a 3-node Win2003 ENT R2 / SP2 cluster hosting 3 named instances
of SQL2000. Two nodes are active (2 instances on one node, 1 instance on
the other) while the third node is passive.
I'm interested in doing some testing of SQL2005 in a cluster environment

This is the second time in less than 2 weeks this has happened to my db
server.
Page (1:14440325), slot 6 for text, ntext, or image node does not exist..
I have performed a dbcc checktable and UPDATE STATISTICS “TBLNAME” WITH

I am a little confused on the term "SQL instances" because I found
conflicting documentation on the subject.
The question is, can I install 4 "instances" of SQL 2005 as "default"
instances on a cluster in different resource groups each one having its own

I was wondering whether it is possible to change IP addresses of cluster
nodes without the need to rebuild the cluster?
I have a SQL server clustered environment with 5 cluster nodes (physical
servers). There are around 10 sql servers build on top of that (with

I want to set up a 4 node cluster where 3 nodes are active and 1 is the
passive node that would take over in case any one of those 3 active nodes
fail. How can I set this up ? Any documentation..
Using SQL 2005..

I have a clustered environment which includes 2 nodes.  The cluster
fails across fine but the only issue is the disks do not appear in My
Computer.  When I connect to the disks through Windows disk management
all the disks are there.

Assuming we have 2 NIC Cards and one port on each of the NIC is NIC teamed
for redundancy, do we use the other port on the NIC for the private network
? Or do we have to bring in a 3rd NIC to set it up ? What would be
recommended ?

I have a 2-node active-passive SQL cluster (with SSIS manually
clustered in the SQL resource group). I want to convert  to active-
active by installing a named instance on the second node. Am I correct
in saying that the new virtual server cannot have its own SSIS