we have an active-active sql cluster configured as follow:
server A - 4gb ram - sql server instance #1
server B - 4gb ram - sql server instance #2
currently each sql instance is configured to use at most 2gb of ram.

I receive a "Cannot generate SSPI context" error message when you try to
connect to a SQL Server 2000 SP3 server computer.
According microsoft's article ID 843248 there is a hot fix. I do not want to
install SP2 just the hot fix.

I am trying to install a named instance on an active/passive cluster using
sql 2000 and windows 2003 both entrprised editions.
HEre is the latest  sqlstp.log which says it failed/.
01:45:22 Begin Setup

What is the better to use in active/active SQL 2000 cluster ?
1 Default instance and  1 named instance
or 2 Named Instances ?
There are any advantages or disadvantages ?

Does anyone know how to enumerate cluster info (Microsoft cluster server
2000) through VBS. But more specifically, is there a way to execute the MOVE
GROUP function from within VBS/VBScript.
Thanks,

To keep the number of driveletters to a minimum, have
the same directory structure on the instances and do
something with disks and performance I tried this:
MSSQL$I1\Data

I have recently setup an active-active Microsoft SQL 2000 cluster on
Windows 2003, and I am starting to wonder how such a setup can reach
the target of 99.99% availability, i.e. 52 minutes and 33 seconds
downtime per year! I know that I should have made some research before,

Hi,
I was told by someone that after install clustering SQL Server 2000 named
instance, it must remove that before installation made the alias. Is that
necessary? What if I leave the alias named instance in the server?

I have Sql2k virtual Server running in Active passive mode on Win2k3
Cluster.
Now my question is how do i configure the Outlook client on those nodes, is
it just a straight install on both the nodes and then confiture it with Sql

My current cluster configuration is Active/Passive, I'm exploring a change to
Active/Active, but I haven't been able to find any informaon on how to do
this, has anyone ever done this?  My reason for considering this is the size
of the current server, and the need to bringup ...

I have an Active/Active cluster with Windows 2003 with SQL Server 2000.  I
am trying to move the cluster disk T: owner to my other group.
I keep receiving the following error:
An error occurred attempting to change the group of the

How many instances of SQL server I need to install in 2 - node server
cluster for Active/Active and for Active/Passive mode 'on each node' ?
Pankaj

I completely understand that SQL-Clustering is failover
technology and not a load balancing technology.
1. What I'm wondering is when you go for Active/Active
mode, then whether both the nodes communicates with the

I have a SQL Server 2000 Cluster with Windows 2000 Server.
The Cluster was set up as a Active\Active and I would like to change it to
Active\Passive.
What do I need to change go from Active\Active to Active\Passive?

This past weekend I was challenged a little in resolving what I hoped was a
simple collation issue. We are running Win2K3 Ent. Clustering Services, SQL
Server 2000 Enterprise, b.8.00.760.
On Friday, 2.11, a user migrated an application to this new clustered setup