I need to add two additional SAN attached volumes to be dependencies
for my SQL Server Cluster resource.  Do I have to restart the cluster
service for this to take affect?  Is there another way for the cluster
resource to re initialize it's dependencies without restarting?

Hi
 Is there any TSQL query/function/procedure that would return the metadata
about the SQLServer cluster?? I need to write a program to get the
information about the SQLServer application cluster. I need to get

I haven't set up a failover cluster before and hope someone can help.
It is Windows 2003, SQL Server 2005 failover cluster. We have set up 2 nodes
emrdb1 and emrdb2, cluster name is emrcluster.
Do we need to add SQL Server Agent as a resource?

We have SQL 2005 installed on Windows 2003 active/passive cluster.  A domain
account is used in the cluster setup.  The sql server name has the 'Enable
kerberos authentication' checked to register and maintain its record in AD.
It can create the computer object in AD but about ...

OS: Windows 2003 SP1 64bit Enterprise Ent.
SQL 2005 Standard Ent SP1 installed.
Active/Passive Cluster setup
I have evicted and rebuild the node and I have verified the cluster groups

we have a 2 nodes win2k server cluster which installed sqlsrv 7.0,  the
primary one failed, and the secondary take over the service as design.
we do not have system backup for the primary node, and we got a blue screen
for that one. it seams like that some registe records are ...

I would like to know if it's possible to have on the same cluster instance,
the cluster server and the analysis services.
Or if I have to configure another cluster instance for the analysis service.
Thanks for your reply.

I need a bit of help with a really strange problem we've got with out
SQL cluster. The setup is - 2 windows 2003 nodes, sharing a das, sql
2000 enterprise sp4. Cluster was up and running for a couple of days,
the one of our offices said they could not connect to it. This box is

All of our Intranet servers are physically moving from one datacentre
to another.  We have already catered for the front-ends, but I need to
find out what needs doing to our clustered SQL Server 2000 environment.
We have a 2 node Win2k cluster, with SQL Server 2000 Enterprise

We need to implement a solution in which two Windows 2003/ SQL Servers 2000
based servers being located behind firewalls in two different locations,
together form SAN attached geo-cluster systems. SQL Server ports will be
opened on firewall to DMZ and accessible by Web servers ...

We're attempting to add a second node to a single node SQL Server cluster
running on Win2k SQL2k SP4. The install appears to work OK but when trying to
bring the SQL Server resource online the resource fails.
After some investigation we've discovered that MSSQLSERVER service has ...

sorry for my lack of knowledge on this issue..
I've installed a Windows 2003 Cluster with SQL 2005. Works like a charm
when i do a failover.
Now i want to make this cluster active/active (multi instance) so no

Hey all,
im having a crisis here... i have 14 days to reloacte my SQL Cluster
from its current SAN to a new storage.
i have 2 win2k3 ent servers running MS cluster service and SQL 2000

Say I have a current standalone SQL 2005 node that is SAN attached.
How can I get it clustered by adding a passive secondary node to it ? Can I
do so ? Or do I have to setup an entirely 2 new clustered set of servers and
move the database from the standalone server to it ?

We are replacing an existing SQL 2000 EE server with a clustered
resource by the same name.  We have done this before, but are running
into an issue on this install.  Here are the steps we have performed:
* Migrate databases as files