SQL Server - SQL 2005 Cluster install error/Group cannot be validated

Asked By SigitasSkublicka

06-Feb-08 10:15 AM

Hello,

I'm installing 2 node failover SQL 2005 cluster. For some reason I'm getting
the following error after I provided domain groups for cluster services:

for this failover cluster. Ask your domain administrator for privileges to
add new accounts to the domain groups, or log on using an account that does
have permission.
The domain group cannot be validated for the service SQL server."

All four global/security domain groups definitely exist. I have created them
myself. I added my personal domain account into all of them, to make sure I
can edit the membership. I’m using my domain account to install cluster, so
from permissions perspective everything should be fine but SQL install wizard
keeps on complaining.

Any ideas / workarounds?

06-Feb-08 10:34 AM

You need to have management rights on the groups.  Just being a member does
not allow you to control group membership.

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

06-Feb-08 10:40 AM

Mr. Hitten,

I am the owner of the groups. Plus my domain account has domain admin
privilages and I have full access to the groups.

Thanks!
Sigitas Skublickas
2024014837

06-Feb-08 10:45 AM

That is definitely an oddball issue.

You should be able to change the group membership.  Have you tried
pre-loading the accounts into the correct groups and see if that shortcuts
the errors?

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

06-Feb-08 11:13 AM

Yes I've tried adding sql service and sql analysis service accounts to all
the groups for testing purposes, but no luck. I also tried to run setup with
different domain admin account but again the same error.

06-Feb-08 11:51 AM

Try running the cluster setup and only including the local node.  You can go
back and add the other node later.  This may simplify the process.

Also, make sure you don't have any AD controllers offline.

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

06-Feb-08 12:19 PM

Goeff,

How to I install SQL on a second node in case i get lucky with the 1st one ?

thanks!
Sigitas Skublickas

06-Feb-08 01:19 PM

Add/Remove programs.

Look up  'Maintaining a Failover Cluster' in BOL for details.

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

06-Feb-08 01:36 PM

Geoff thanks for the information! I really appreciate your help.

domain Global/Security groups on the domain. Honestly I have no clue why it
did not work the first time.

My Sql database service and Analysis service install failed when I tried to
deploy them into two nodes at the same time. As per your suggestion, I'm
trying to install everything on the first node first and then I'll try to add
the second node. Somehow I feel that I might need your suggestions again :)

Thank you one more time!!!

Thanks!
Sigitas Skublickas