SQL 2005 Cluster install error/Group cannot be validated

Mr. Hitten,

I'm 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

"Geoff N. Hiten" wrote:

> 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
>
>
> "Sigitas Skublickas" wrote in
> message
> > 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:
> >
> > "You don’t have privileges to add accounts to the domain groups specified
> > 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?
> >
>
>
 >> Stay informed about: SQL 2005 Cluster install error/Group cannot be validated 

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


"Sigitas Skublickas" wrote in
message
> Mr. Hitten,
>
> I'm 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
>
> "Geoff N. Hiten" wrote:
>
>> 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
>>
>>
>> "Sigitas Skublickas" wrote
>> in
>> message
>> > 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:
>> >
>> > "You don’t have privileges to add accounts to the domain groups
>> > specified
>> > 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?
>> >
>>
>>
 >> Stay informed about: SQL 2005 Cluster install error/Group cannot be validated 

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.

"Geoff N. Hiten" wrote:

> 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
>
>
> "Sigitas Skublickas" wrote in
> message
> > Mr. Hitten,
> >
> > I'm 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
> >
> > "Geoff N. Hiten" wrote:
> >
> >> 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
> >>
> >>
> >> "Sigitas Skublickas" wrote
> >> in
> >> message
> >> > 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:
> >> >
> >> > "You don’t have privileges to add accounts to the domain groups
> >> > specified
> >> > 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?
> >> >
> >>
> >>
>
>
 >> Stay informed about: SQL 2005 Cluster install error/Group cannot be validated 

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




"Sigitas Skublickas" wrote in
message
>
> 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.
>
> "Geoff N. Hiten" wrote:
>
>> 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
>>
>>
>> "Sigitas Skublickas" wrote
>> in
>> message
>> > Mr. Hitten,
>> >
>> > I'm 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
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> 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
>> >>
>> >>
>> >> "Sigitas Skublickas"
>> >> wrote
>> >> in
>> >> message
>> >> > 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:
>> >> >
>> >> > "You don’t have privileges to add accounts to the domain groups
>> >> > specified
>> >> > 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?
>> >> >
>> >>
>> >>
>>
>>
 >> Stay informed about: SQL 2005 Cluster install error/Group cannot be validated 

Goeff,

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

thanks!
Sigitas Skublickas

"Geoff N. Hiten" wrote:

> 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
>
>
>
>
> "Sigitas Skublickas" wrote in
> message
> >
> > 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.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> 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
> >>
> >>
> >> "Sigitas Skublickas" wrote
> >> in
> >> message
> >> > Mr. Hitten,
> >> >
> >> > I'm 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
> >> >
> >> > "Geoff N. Hiten" wrote:
> >> >
> >> >> 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
> >> >>
> >> >>
> >> >> "Sigitas Skublickas"
> >> >> wrote
> >> >> in
> >> >> message
> >> >> > 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:
> >> >> >
> >> >> > "You don’t have privileges to add accounts to the domain groups
> >> >> > specified
> >> >> > 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?
> >> >> >
> >> >>
> >> >>
> >>
> >>
>
>
 >> Stay informed about: SQL 2005 Cluster install error/Group cannot be validated 

Add/Remove programs.

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

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


"Sigitas Skublickas" wrote in
message
> Goeff,
>
> How to I install SQL on a second node in case i get lucky with the 1st one
> ?
>
> thanks!
> Sigitas Skublickas
>
> "Geoff N. Hiten" wrote:
>
>> 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
>>
>>
>>
>>
>> "Sigitas Skublickas" wrote
>> in
>> message
>> >
>> > 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.
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> 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
>> >>
>> >>
>> >> "Sigitas Skublickas"
>> >> wrote
>> >> in
>> >> message
>> >> > Mr. Hitten,
>> >> >
>> >> > I'm 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
>> >> >
>> >> > "Geoff N. Hiten" wrote:
>> >> >
>> >> >> 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
>> >> >>
>> >> >>
>> >> >> "Sigitas Skublickas"
>> >> >> wrote
>> >> >> in
>> >> >> message
>> >> >> > 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:
>> >> >> >
>> >> >> > "You don’t have privileges to add accounts to the domain groups
>> >> >> > specified
>> >> >> > 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?
>> >> >> >
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
 >> Stay informed about: SQL 2005 Cluster install error/Group cannot be validated 

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

"Domain Groups" issue went away after I deleted and recreated identical
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

"Geoff N. Hiten" wrote:

> Add/Remove programs.
>
> Look up 'Maintaining a Failover Cluster' in BOL for details.
>
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Sigitas Skublickas" wrote in
> message
> > Goeff,
> >
> > How to I install SQL on a second node in case i get lucky with the 1st one
> > ?
> >
> > thanks!
> > Sigitas Skublickas
> >
> > "Geoff N. Hiten" wrote:
> >
> >> 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
> >>
> >>
> >>
> >>
> >> "Sigitas Skublickas" wrote
> >> in
> >> message
> >> >
> >> > 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.
> >> >
> >> > "Geoff N. Hiten" wrote:
> >> >
> >> >> 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
> >> >>
> >> >>
> >> >> "Sigitas Skublickas"
> >> >> wrote
> >> >> in
> >> >> message
> >> >> > Mr. Hitten,
> >> >> >
> >> >> > I'm 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
> >> >> >
> >> >> > "Geoff N. Hiten" wrote:
> >> >> >
> >> >> >> 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
> >> >> >>
> >> >> >>
> >> >> >> "Sigitas Skublickas"
> >> >> >> wrote
> >> >> >> in
> >> >> >> message
> >> >> >> > 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:
> >> >> >> >
> >> >> >> > "You don’t have privileges to add accounts to the domain groups
> >> >> >> > specified
> >> >> >> > 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?
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
>
 >> Stay informed about: SQL 2005 Cluster install error/Group cannot be validated