SQL 2005 Cluster install error/Group cannot be validated

#81

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:

Quote:

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" <SigitasSkublickas (AT) discussions (DOT) microsoft.com> wrote in
message news:1320286D-8664-4FB1-A4C0-63E019BA21C2 (AT) microsoft (DOT) com...
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" <SigitasSkublickas (AT) discussions (DOT) microsoft.com> wrote
in
message news:EFF4AD90-38D4-4B59-B329-20FD2BFEC2D1 (AT) microsoft (DOT) com...

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" <SigitasSkublickas (AT) discussions (DOT) microsoft.com
wrote
in
message news:5B75650D-3B35-49F2-9D81-83127306534C (AT) microsoft (DOT) com...
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" <SigitasSkublickas (AT) discussions (DOT) microsoft.com
wrote
in
message news:8EC4E6C0-2D07-4926-AC27-3535EA9D39F8 (AT) microsoft (DOT) com...
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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 2005 Cluster install error/Group cannot be validated

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: SQL 2005 Cluster install error/Group cannot be validated - 02-06-2008 , 12:36 PM