Has anyone seen that if you install SP4 on a SQL 2000 cluster that it will
change the failover setting to affect the group regardless of its previous
state? It doesn't do it for Full Text the first time you apply the SP but it
will if you reapply the SP. It also sets the setting ...

I am trying to run the 'SQL Server Surface Area Configuration' for our SQL
2005 Cluster Server (passsive/active). The Configuration does point to the
Virtual IP of SQL cluster. I still have the following error message. I try to
run the Configuration on active node, passive node, ...

I realized an active/passive Windows Cluster from two IBM xSeries346 with
Windows 2003 Enterprise Edition SP1 (patched..) and I use like a shared disk
an IBM EXP400 (certified..).
When Active server go down, passive server can't do automatically the

I have a W2K3 cluster hosting a default and named instance of SQL Server.  We
want to move the named instance to it's own cluster, how best can I do this?  
The disks are presented to the nodes from our Dell SAN.
Thanx.

When installing SQL 2005 on a 2 node cluster, the install fails saying setup
on the remote machine failed, check the task scheduler log.  The log on the
remote machine says "Unable to start task....Access is denied".  Any idea how
to get around this?

What is the registry path for checking if there is a SQLServer installed as a
virtual server on the machine. What I am trying to get here is if I logged on
to a machine and I want to read from registry if there is any SQL Virtual
server installed on this machine or not. I need to ...

Is it possible to use a single storage with multiple SQL Servers??
Regards
Ahmad Zia

We currently have a (2) node active/active cluster with each node ideally
hosting (2) virtual servers and their instances.  We want to split the
cluster into (2) active/passive clusters and move what normally resides on a
given node to it's own cluster.  Here is the catch.  We ...

I have a very bizarre situation with a single instance/two node/W2K3
cluster.  The issue I am seeing is that the passive node is starting the sql
server services even though the resources are not owned by that node.  The
restarts are occuring every five minutes.  The system log ...

Am i able to restore system databases to sql2005 from sql2k SP4 backup
dumps?
Thanks

I have a new cluster server not sure whether I should install sql 2k or sql
2005.
I need to move all prodcution dbs from regular sql2k server to the cluster
box.

We are move regular sql 2k sp4 server to a cluster server (Without SAN).
In general, what is the best way do setup: active/active notes or
active/passive?
Thanks

Hey All,
I've tried this a couple of times and I keep getting the same result...  
When I install SQL 2005 Std it only installs the SQL Management Studio and
most of the client tools on the actual node that I'm running setup.exe from.  

I would like to know if I can move my active/passive SQL clusters into a more
cost effective four node cluster (3 active and 1 passive).  Is there a matrix
or document somewhere on Microsoft's site that indicates what configurations
are officially supported and considered "best ...

I am setting up a 2 instance SQL 2K (32-bit with SP4) cluster on a 2 node
Win2003 x64 ENT cluster.  Each node has 4 x 3.0 XEONs with 8MB L3 cache and
16 GB RAM.  I am looking for info on any switch settings I should use in the
startup file for the servers to take advantage of the ...