Friday, February 24, 2012

Domain Groups For Clustering Service ?? SQL Server 2005

When I install the Cluster with Version of SQL 2005 CTP September ...
After the Service Accounts (Clusters) page,
Domain Groups For Clustering Service Page appears.
How Can i configure this page...there is no information about it on BOL of
SQL 2005
In my opinion , fill them with New SQL Groups is created when SQL Server
Installs such as
SQLServer2005MSSQLUser$InstanceName,SQLServer2005S QLAgentUser$InstanceName
and SQLServer2005MSFTESQLUser$InstanceName.
But in this Phase, those group was not created automatically...
So, I try to generate those groups Manually, but Failed...with error message
like "One or more domain groups could not be verified ..."
And i Try to use Domain Admins...but Failed with same error messages...
i found about BOL directions in "Setup\help\1033" folder like follows
(
For each clustered service in the instance of SQL Server that you are
installing, enter the domain and group name in the format
<DomainName>\<GroupName>, subject to the following guidelines:
The domain and group names must already exist. If necessary, ask your domain
administrator for the names of existing domain groups, or to create domain
groups for your failover cluster.
The account under which SQL Server Setup is running must have privileges to
add accounts to the domain groups.
Each service should use a different domain group.
The SQL Server domain groups should not be shared with any other application.
Note that SQL Server accounts will not be removed from the groups if SQL
Server is uninstalled or if the accounts are changed. A domain administrator
must ensure that all unwanted accounts are removed following removal of SQL
Server.
)
So, I made three domain groups and put into builtin Administratos group.
and then proceed ahead.
Failed with same error messages...
help me...!!!
"JEYAI"?? ??? ??:

> When I install the Cluster with Version of SQL 2005 CTP September ...
> After the Service Accounts (Clusters) page,
> Domain Groups For Clustering Service Page appears.
> How Can i configure this page...there is no information about it on BOL of
> SQL 2005
> In my opinion , fill them with New SQL Groups is created when SQL Server
> Installs such as
> SQLServer2005MSSQLUser$InstanceName,SQLServer2005S QLAgentUser$InstanceName
> and SQLServer2005MSFTESQLUser$InstanceName.
> But in this Phase, those group was not created automatically...
> So, I try to generate those groups Manually, but Failed...with error message
> like "One or more domain groups could not be verified ..."
> And i Try to use Domain Admins...but Failed with same error messages...
|||You need to manually add the service accounts you specify during setup into
the groups before running setup (if you're having this issue - you shouldn't
really have to do this). I had the exact same issue and manually adding the
service account to them worked fine. Generally there will be 3 groups
(SQLServer/Agent + FullText). If you use the same service account for the
services then just add that to each of the 3 domain groups you create.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JEYAI" <JEYAI@.discussions.microsoft.com> wrote in message
news:79B54E21-BEB4-43E9-9880-7EAFE0FD5F92@.microsoft.com...[vbcol=seagreen]
>i found about BOL directions in "Setup\help\1033" folder like follows
> (
> For each clustered service in the instance of SQL Server that you are
> installing, enter the domain and group name in the format
> <DomainName>\<GroupName>, subject to the following guidelines:
> The domain and group names must already exist. If necessary, ask your
> domain
> administrator for the names of existing domain groups, or to create domain
> groups for your failover cluster.
>
> The account under which SQL Server Setup is running must have privileges
> to
> add accounts to the domain groups.
>
> Each service should use a different domain group.
>
> The SQL Server domain groups should not be shared with any other
> application.
>
> Note that SQL Server accounts will not be removed from the groups if SQL
> Server is uninstalled or if the accounts are changed. A domain
> administrator
> must ensure that all unwanted accounts are removed following removal of
> SQL
> Server.
> )
> So, I made three domain groups and put into builtin Administratos group.
> and then proceed ahead.
> Failed with same error messages...
> help me...!!!
> "JEYAI"? ? ?:
|||Thanks Jasper,
Following your directions,
I made three domain groups named as SQLUsers,AgentUsers,FTUsers
and put them into Built in Administrators group.
and then put the Service Account named as SQLService and administrator
account into three new groups.
But, in the page of Domain Groups For Clustering Service ,
Same Error message occured...
What did i miss ?
"Jasper Smith"?? ??? ??:

> You need to manually add the service accounts you specify during setup into
> the groups before running setup (if you're having this issue - you shouldn't
> really have to do this). I had the exact same issue and manually adding the
> service account to them worked fine. Generally there will be 3 groups
> (SQLServer/Agent + FullText). If you use the same service account for the
> services then just add that to each of the 3 domain groups you create.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "JEYAI" <JEYAI@.discussions.microsoft.com> wrote in message
> news:79B54E21-BEB4-43E9-9880-7EAFE0FD5F92@.microsoft.com...
>
>
|||The readme file describes this.
In section 3.5.15, there are descriptions of Security Groups and Domain
Controllers.
Microsoft SQL Server September 2005 Community Technology Preview
http://download.microsoft.com/downlo...up_issues_238p
Sincerely,
Anthony Thomas
"JEYAI" <JEYAI@.discussions.microsoft.com> wrote in message
news:5B999CCC-1E77-4F3D-B52B-E34DC95752BA@.microsoft.com...[vbcol=seagreen]
> Thanks Jasper,
> Following your directions,
> I made three domain groups named as SQLUsers,AgentUsers,FTUsers
> and put them into Built in Administrators group.
> and then put the Service Account named as SQLService and administrator
> account into three new groups.
> But, in the page of Domain Groups For Clustering Service ,
> Same Error message occured...
> What did i miss ?
> "Jasper Smith"? ? ?:
into[vbcol=seagreen]
shouldn't[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
domain[vbcol=seagreen]
privileges[vbcol=seagreen]
SQL[vbcol=seagreen]
of[vbcol=seagreen]
group.[vbcol=seagreen]
BOL[vbcol=seagreen]
Server[vbcol=seagreen]
SQLServer2005MSSQLUser$InstanceName,SQLServer2005S QLAgentUser$InstanceName[vbcol=seagreen]
messages...[vbcol=seagreen]

No comments:

Post a Comment