Is setting a static port for SQL server possible on a cluster? I tried this
and the service would not start, so I had to run the cluster recovery
utility to get the service to start again.

i have a 2-node cluster  with SQL 2000. I've received many complaints
about the performance. My users tell me that the server is very slow.
The boxes are new (2 cPu Intel Xeon 2'8 GHZ and 4 Gb RAM, ...)
I have used PerfMon to see tipical counters and have seen about 100

I'm about to install a 2-nodes Windows 2003 Cluster, with 2 SQL Server 2005
instances: I've read in MS documentation that clustering MS-DTC is
recommended, but I can't find how much disk space shoud I reserve for it
group: can you tell me what is the recommended disk space for it ...

Is there a manual procedure whereby I could get a replacement node up to SP1
binaries without having to interrupt service by failing the cluster over
just to apply SP1 to the newly rebuilt node?
Hopefully I'm making sense - the node that went down was a passive node and

I've a challenge of upgrading the curent cluster hardware.
my current config:
node1 and node2 with a vs1\sql1 and vs2\sql2 respectively attached to SAN
It's important to keep the same IP address and preferred the instance name

I currently have an active/passive cluster acting as our OLTP TX database
server that is replicating to another active/passive cluster acting as a
Reporting database server.
I have heard that if the database is read-only (e.g. reporting server) that

My configuration is Windows 2000 Adv. server SP4 and two istances of SQL
2000 sP3.
I just updated the OS from sp3 to SP4 last night and now when i open Ent.
Mgr from any desktop or console pc and when opening the Database folder on

I will have to move a 2-node SQL2005 MSCS cluster to new servers.
Wonder if I could just
- remove node1 from cluster
- add node3 to cluster

What are the step to be followed change the SQL Server Virtual IP address.
SQL Server 2000 Enterprise version with SP3
Windows Server 2003 Enterprise Edition

We have a 3rd party vendor application that runs on IIS and connects to a
back end SQL Cluster.  Sometimes a user will try and run a commission report
and the SQL server takes a big hit on the CPU's (Dual 2.0 Ghz Xeon's) and I
will get a error in MOM 2005 that the  "Server ...

I really need some guidance on how to restore this.  Your help will be very
much appreciated.
Setup: 2 node clustering on Windows 2000 Advance Server with MS SQL 2000
Enterprise Edition.

I have a two node cluster, and both nodes are up (this is a testing
environment) - both Virtual SQL servers are up as well. The cluster
resources are in their own group (ie,  cluster IP, cluster name, Q drive,
etc). The question is...

What are the reasons that you are not allowed to install the SQL Server
program files on a shared disk that's accessible from all cluster nodes?
We have a custom notification application that's written as a windows
service.  We want to add it to the same resource group as the SQL ...

I have a 2-Node Active/Active SQL2000/SQL2005 Cluster sitting behind an ISA
box. The SQL2000 which is a non-named intance i.e. default uses port 1433. I
checked this through the SQL 2000 Server Network Utility.
I then checked the SQL2005 named instance using the SQL Server ...

I am facing problem of recurring corruptions with sql 2000 server sp3a
windows 2000 advanced server failover cluster. is it wise to apply sp4? or is
it risky at this stage
rgds