I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed.  When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.  I
can not bring them online manually either.  The ...

We have an application  running on an NLB cluster in the DMZ.
Application data is stored on a standalone SQL 2005 Std server located
not in the DMZ but inside the company's private network.  Have
recently setup a 2-node SQL 2005 Std failover cluster running on

we have 4 identical nodes each with 1TB RAID10 drive. Accessing a
quorum over Fibre Channels is also possible
We want the best mix of performance and data safety.
I'm not sure if I should create

I have read this great bit of news, however I cannot find any documentation
on how to configure it.  Can someone point me in the right direction?
Thank you for your time in advance.

We have a 2 node 64-bit Windows 2003 Active/Active Cluster with 2 instances
on each node. Each node has 2 virtual servers/named instances; 1 SQL 2000
(32-bit) and 1 SQL 2005 (64-bit). Thus the setup is as follows:
SQLNode1:

Hello
I have the folowing situation on my company:
Someone configured an Active-Passive SQL 2K5 Cluster configured with only
one group!!!

I have a MSCS Cluster residing within two esx hosts, there are three
shared disks and a quorum drive, each is currently available to the
server and cluster.  The problem is during the installation I was only
able to select one of the shared drives.

Please, how can I write, after clustering process, the final clusters in a
table?
Best,

I'm trying to install SQL Server 2005 on a one-node Windows Server 2008
failover clustering, but I'm getting the following error message:
"The drive specified cannot be used for program location. Program files must
be installed on a valid local disk available on all cluster nodes. ...

My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource ...

I have to re-IP our SQL 2005 failover cluster to a new IP and I have looked
at the following KB articles.
How to change the network IP addresses of SQL Server failover cluster
instances

I tested a failover cluster solution with Windows 2003 and SQL Server 2005
using 2 nodes with optimal result.  Now I'm interested to add a third node
and see what happens, but before that I have some questions.
1 - How nodes will work in case of failover?, will use a round robin

Currently, our Prod databases located in the 3 SQL instances on the 2
physical nodes cluster servers. I need add three new (powerful) nodes to
existing 3 instances. These instances installed SQL Server 2005 Enterprise
Edition with Post SP2 (3161) version. For the security purpose ...

I have 2 nodes on cluster. I installed SQL clustering. Recently, there is a
need to have IP changes to the environment. I followed closely from Microsoft
KB article
Changing the IP address of network adapters in cluster server

I try to install MS SQL 2000 Enterprise to an existing Cluster. When it ask
me i put the SQL Server Virtual name i type it and when i press Next, the
Setup window close and i can't continue the installation.  
After a while i get this message in the Application Event Viewer :