I am a newbie to Clustering. I dont know how to decide how many number
of nodes I need to install. For example, if I have 4 SQL database servers
and all 4 servers should be highly availabe and automatically failover. In
this case how can I configure clustering?

Is Mgmt. Studio part of a clustered resource, say the DB Engine ?
On a two node active-passive Win Enterprise Server 2003 / SQL Standard 2005
cluster, when node 1 is active, I can get to Mgmt. Studio on the virtual
resource (RDP).  When node 2 is active, I cannot.  But I can ...

We have one server runs all our databases and websites and we have just
bought an identical server to mirror all files and databases if there is
a problem we will switch the firewall rules to bring the second server
online. What is the best way to update SQL Server 2005 on the ...

I'm not completly sure how to phrase this question.
In the 2 node cluster I'm working with, I noticed that there is a database
named "Utility" on both nodes of the cluster, which confuses me. I thought an
instance was clustered, not a database, so finding the duplicate DB doesn't

I'm trying to install sql server 2000 on windows 2003 SP1 and getting
below error message.
14:22:57 End Action : Run setup on cluster nodes
14:22:57 SetClusterSecuritySQL (TESTAD01\SQLSRV) and (TESTAD01\SQLSRV)

I am new to clustering and would like to implement and active/active SQL
cluster, which would allow the functions of one of the nodes to fail over to
the other in the event of a problem.  
I have two identrical servers in terms of hardware connected to a SAN and

Here's my question.  I'm new to SQL and clustering but I'm on my way to
having my cluster set up on two W2K3 64 bit servers.  Everything is patched
up and ready for my installs.  One server will have SQL 2K and SQL 2K5 on the
other.  My question is this:  I have a HP storage ...

Does anyone have a link for the essential local security policy settings
that are needed by the domain account
that is used to start a clustered MS SQL Server 2000 instance?
I have been to MS Technet and not found a really explicit list of privs as

I was trying to take a quick back of a db and wanted to restrict access for
a short time and set it to single user access. Now I am wantting to change
it back but the gui is not allowing my to do so. What is quickest way to
change it back?

I am trying to setup an active/passive cluster (everything on 32bit
plateforme) on a virtualized environment. I followed several docs provided by
microsoft especially the one on /prodtechnol/virtualserver/deploy/cvs2005.mpx.
Regarding the w2k3 itself  it seems everything is ...