I have two node SQL Enterprise installed on a Windows 2003 cluster running
active -active. I would like to add a third node so that it would become 2
active and 1 passive . Is this feasible ?
Also , can someone tell me how can I make the third node standby for the

   I need to install sp3a in a recently added node, but I added this second
node after I had installed SP3A in the active node, so, when I installed
SP3a in the first and active node, it was not installed in other servers. I
have the following scenario

The instal fails when we try to cluster SQL 2000 on windows 2003 server.
I tried new instances or standalone instals but i had the same
results<<failure>>

Recently set up a cluster and it seems to be working up to a point.
Have run into a problem trying to ping the cluster IP address from a
node not owning any resources, or from outside the cluster. Pinging
from the node that owns everything works, and if I move over the MSDTC

I am looking to see if anyone has had this problem or ideas of what I might
try.  We have been running a Windows 2000 cluster connected to a powervault
for two years as a single instance with no problems.
I am in the process of setting of a Windows 2003 Active-Passive two node

I've got a bit of a problem on a clustered sql server.  I don't know
if the cluster has anything to do with it, this is an entirely new
configuration for our company.  We've moved out of the days of using
"white-box" pcs for servers to two dl380s clustered with an msa 1000

The sql server service doesn't start b/c it appears the password isn't
being stored after the node reboots. I've gone into Enterprise Mgr to
retype the domain acct and pwd and save... I've also retyped the pwd
from Manage/Services. It stores it up until the node is rebooted. Then ...

Has anyone created a clustered sql2000 instance on windows 2003 in different
geographical areas? I gather this can be done, but there is no shared
storage as such. I believe one has to replicate data another way.
I am looking for some docs on this before I dive in!

OK. This is getting frustrating. I have tried over and over to set up SQL Server
2000 in my 2 node cluster. I keep getting the following messages:
This one occurs during the setup:
----- CUT -----

i wanted to have my 2 node server cluster as active-active. DO i need to put
the named pipes in both servers before i install sql2000 or just on the one
that i wanted to install the instance?i will have VSS1/INST1 and VSS2/INST2.
do i need to put both of them in CNU and install ...

Hello,
We are moving from a 2 node, Acitive-Passive cluster to a 4 node cluster; 3
Active 1 passive.
We have 3 Virtual Servers. We have defaulted one virtual server per active

Has anyone clustered SQL server 2000 using a NAS server (eg. Dell PowerVault
745N) as the shared storage? I know that SAN is recommended but costs are
vastly higher. Any reasons as to why it shouldn't be done would be helpful.
thanks - pete.

Hi, is there any step by step guide on setting up multiple instance of
Microsoft SQL server cluster with more than 2 /3 active nodes ? There is no
such training course available anyway ?
Thanks A Lot  !

Is it possible to create Fail-over Cluster with 64-bit (Itanium2) and 32-bit (Intel Xeon) nodes?

My boss issued a challenge at lunch today:  Find out if SQL can cluster to
support thousands of end-users with hundreds of thousands of trans per
minute, or we start looking at Oracle.
What do I say to him?