I am new on both SQL and windows cluster. Our company is trying to deploy a
HA SQL system, which I need to install SQL2005 to windows cluster. My
question is:
Since windows cluster will share one back end storage chassis, where should

I am installing a SQL 2005 active/active cluster. The system consistency
checker is reporting that a "pending system restart" is needed, but I have
restarted multiple times on both nodes.
because of this, I am unable to failover the SQL instance to the node that

We have a sql2005 active/passive win2003 x64 cluster. when the db's are on
the active node..we see all of the sql tools available. on the passive node,
we don't. is this by design as we did a complete install. any help is
appreciated. thx. steve

I am Sql server administrator in a company and I don't have experience of sql
server 2005 failedover cluster. Recently my company decides to use cluster to
conduct disaster recovery strategy. I want to make a preperation about it,
could somebody recommend some online document to ...

Hi All: I have an active/passive SQL 2005 Cluster set up on a subnet that
with a local Active Directory domain. Any computers in the domain can
connect to it using "SQLCluster" SQL Mgmt Studio and connect with Windows
Authentication.

I cannot install SP2 on a new node that was added after SP2 applied to the
primary.
We had the following scenarios. Node A SP2, node B RTM.
Scenario 1) Resources moved to node A (also MSDTC and Cluster group). Setup

I have two nodes (active/passive) in my cluster that I am trying to upgrade
from 64-bit SQL 2005 SP1 to SP2. I followed Microsoft's instructions and
logged into the active node with Admin Privleages. However, the setup keeps
failing when attempting to upgrade the Database ...

Hi,
We have a default clusterd SQL server 2005 with sp2 installed in one cluster
group and then I have installed a default SSAS clustered instance in another
cluster group and it works fine (can failover and user can connect). However,