We are in the process of deploying AS on a 2-node Active-Passive SQL Server
2000 MSCS cluster. I understand there is a MS white paper on how to cluster
it which requires lots of manual changes. If we were to follow this paper,
would it be possible to have the AS tools shared ...

We cannot seem to figure out why our new SQL 2000 installation will
only seem to operate correctly on one of the nodes.  When running on
Node2, it works fine, but will not start completely when failed over to
Node1.  Both nodes have been upgraded to SP4, but Node1 has never run

I am searching for a list of published hotfix posted after SQL Server SP4.
Is there such a link or URL, on the Microsoft site?
Thank you for your time.

Are there any white papers and other resources where I may obtain information
on setting up active/active clustering in SQL Server 2005?
Thank you.

We have a SQL cluster across 2 Win2k3 servers, running active/passive.  About
3 months ago, the power went out in our building briefly (less than one
second).  All our servers are connected to UPS's, so they didn't miss a beat.
However, we do not own the switches (we're at a ...

Hi,
I have a three nodes cluster with Win 2003. On that I have four SQL
intances. MSTDC is installed  on the Quorum. When a failover happens, the SQL
groups start before MSDTC and that create a problem with the transactions

We have an existing cluster (2003) with a single active node for SQL Server
2000. I added an additional node, ran the SQL 2000 install which copied the
binaries, etc to it. But when attempting to failover to this new node, all
resources came online except  for the SQL Server, ...

For a non-clustered index, would it have a performance difference between
varchar(20) and char(20) , using only either one of them.
thx!!!

OK.  I have a two node SQL cluster.  Everything works fine when node 2 is
active.  When node 1 is active everything comes up fine and is reachable.
After about 5 minutes, the sql instance is unreachable by name.  Here is the
filtered cluster log using cluster diag:

I have a cluster using adapter teaming and it seems that when the virtual
server is hosted on node 1, it is not able to resolve past the local
segment.  On the other node 2 it works correctly.
Anyone have a ny input on this issue?

We Want to do clustering of 2-3 SQL Servers. I m completely new to this
concept. Any pointers around the same are most welcome.
Regards
Priyanka

Currently I need to deploy a cluster environment for my client. I've
found many topics discussing about whether Sql 2000 cluster requires
DTC to operate, but still see no final answer for it. Can someone
please help me answer this question?

I'm trying to install cluster service on a Windows 2003 Server Enterprise
Edition SP1.
I've configured Network and Disk.
When I try to create a new a new cluster for the first node, I receive this

Is it possible to take 5 servers and make 4 individual clusters and
share the 5th server amongst all of them as the failover node? These
clusters would be running SQL 2000 and attached to a SAN enviroment.

we have 2-node active/active sql 2k sp3 environment and planning to deploy
sql sp4.
we analyzed the microsoft setup documents but they are not clear and user
friendly. anyone knows that how we can install sp4 on 2-node active/active