Re: SQL Server Cluster Setup

Did you ever get this sorted? I'm hitting exactly the same problem.

"Djeff" wrote:

I created the groups and i'm the owner but the SQL system configuration check
failed on the second node

"Geoff N. Hiten" wrote:

Domain account, not domain admin account. You do need to be owner of the
groups specified in the cluster setup.

Don't use built-in groups for that.

Never use domain admin accounts for SQL service accounts in a cluster.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Djeff" <Djeff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4B0BC1F4-0112-4E54-AB4E-2729FBEA8122@xxxxxxxxxxxxxxxx
Currently i'm not domain admin but i use an account that is in the local
administrator on each server

"Geoff N. Hiten" wrote:

Your install account has to be a domain-level account with admin rights
on
all nodes.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Djeff" <Djeff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BE4088B3-7F59-41E2-B7E3-FB570E6BEEEB@xxxxxxxxxxxxxxxx
Hello all,
i'm trying to install SQL Server 2005 Enterprise Edition on a two nodes
cluster but the Check Wizard is unable to check services on the second
nodes

WMI Service Requirement
Unable to process the check.

What i heve to do on the second node to have the right to check ?

thanks




.

Relevant Pages

  • Re: Setting up Server Cluster for SQL Server - 2 Servers and a NAS
    ... I agree 100% with Geoff. ... things you can do with windows and an app like SQL Server on top of it. ... Trying to cluster with equipment that is not on the clustering HCL is just ... > As for your hardware, you don't have the pieces for a cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Passive node starting the SQL Server services - services set t
    ... The point of a cluster is to have redundant hardware as a hot spare. ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ... the preferred owners for the resource group and possible ...
    (microsoft.public.sqlserver.clustering)
  • Re: Sql Cluster server on win 2003 and sql 2005 ent.
    ... Geoff, I need 2 instances are good enough for me at db point of view. ... Standard Edition can cluster up to two nodes with four processor sockets ... Microsoft SQL Server MVP ... what is the best way do setup: active/active notes or ...
    (microsoft.public.sqlserver.clustering)
  • Re: Setting up Server Cluster for SQL Server - 2 Servers and a NAS
    ... The software company is going to ... "Geoff N. Hiten" wrote: ... There is a specific Cluster Hardware ... > I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Seperating Second Instance to Own Cluster
    ... Senior Database Administrator ... Microsoft SQL Server MVP ... Present LUNs to new cluster ... ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
Loading