Right now I am working on a project that requires two active SQL servers with
different local web servers accross geographic locations.  I read an article
on Active-Active SQL servers and am seeing some possiblity in SQL 2005 for
this situation to work but in SQL 2000 is there ...

I am having difficulty changing the virtual ip address of a sql 2000 cluster
on Windows 2003. The disk fails and I have tried to change per microsoft
articles to fix, without success. I am thinking of unclustering the servers
in SQL and then trying. I found articles to do this in ...

Plat form: Windows 2003 enterprise ed,
SQL Server 2000 Failover Clustering SP3A enterprise ed.
Action: Change some registry keys after bring SQL resources offline.
I am trying to change the following registry keys to point to new location

Error 17 SQL Server  does not exist or access denied
We have two clusters , one with four nodes, the other with two.
We are encountering difficulties on some with communication going one way,
say between SQL instance 1 to the default instance running on the other node.

My instance name on one server in a cluster is 'PSPSQL1\PSP1_INST1'.  I have
a linked server with another instance on another server -
'PSPSQL2\PSP2_INST2'.  When I query a a table across server referenceing it
as follows - PSPSQL1\PSP1_INST1.databasename.dbo.tablename - I get an ...

Is anyone running SQL 2000 using the Veritas cluster service vs. MSCS? For a
simple two node SQL 2000 cluster (A/P), does Veritas add much value?
Derek

Hello group,
today we tried to install a SQL 2k cluster very unsuccessfully. Would
need your support.
What we have:

We are building a new Win2k Adv, SQL 2000 cluster.
what is the best way to install the anti virus software after the cluster
has been built.....do we need to pause the the node, and then install anti
virus software etc....

Morning,
We have two nodes in a sql cluster.  The "Lan" connection on one of the
servers fails at different times and I can't track down the problem and I am
not sure where to start.

I am trying to add a new physical disk resource yet
cluster services will not recognize the new hard drive.  
Can anyone point me in the correct direction to add a new
hard drive to the cluster as a new resource?

I have a Windows 2003 server running SQL 2000 with Tomcat 5.0. I need to have
some kind of failover solution for SQL and a NLB for Tomcat. I came accross
an article that states that NLB is not intended for SQL.
My final goal is to have two clusterd servers, both running SQL and ...

We have a 2 node active/passive SQL2000 cluster running on a Windows 2000
advance server cluster.  The cluster cannot failover.  The SQLagent crashes
on a failover attepempt.  The following event is generated in the
application log of the node we are trying to failover to.

We have the following setup:
Windows 2003 Server Enterprise edition Cluster with 2 nodes. SQL Server 2000
Enterprise edition Virtual Server1 - currently Active/Passive Cluster.
Shared storage and Quorum drive on SAN.

I know I've been asking a lot of dumb questions here lately but - One must
learn somewhere.
In my test lab cluster that I'm building, W2k3 Cluster admin put each of my
physical disks in its own group.  Now I'm keep one for the cluster group, and

All,
My problem is a funky one.  I have a 2003 cluster that appears to be
properly functioning.  and SQL 2000 in Active/Active
I have 3 Instances of SQL Server 2 were running on Node A and 1 on Node B.