Re: Domain Groups For Clustering Service ???? SQL Server 2005

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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/download/3/b/f/3bf62c7b-6f45-46d6-bbac-15c654835383/ReadmeSQL2005.htm#_3462_setup_issues_238p

Sincerely,


Anthony Thomas

--

"JEYAI" <JEYAI@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B999CCC-1E77-4F3D-B52B-E34DC95752BA@xxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:79B54E21-BEB4-43E9-9880-7EAFE0FD5F92@xxxxxxxxxxxxxxxx
> > >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,SQLServer2005SQLAgentUser$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...
> >
> >
> >


.

Relevant Pages

  • Re: Newbie question on SQL connection
    ... > Let me educate you about SQL Server security. ... granting permissions to these accounts in SQL ... > maintain its own user accounts, which are separate from domain user ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Sql server 2005 clustered service group
    ... For each clustered service in the instance of SQL Server that you are ... administrator for the names of existing domain groups, ... Note that SQL Server accounts will not be removed from the groups if SQL ... I see with installing SS2005 cluster if forces me to use domain accounts ...
    (microsoft.public.sqlserver.setup)
  • Re: Domain Groups For Clustering Service ???? SQL Server 2005
    ... You need to manually add the service accounts you specify during setup into ... services then just add that to each of the 3 domain groups you create. ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.clustering)
  • Re: Minimum rights for SQL Agent
    ... administrator, or domain administrator accounts. ... SQL Agent connection to SQL Server with Admini prev. ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to Backup on Network
    ... The correct permissions will be set if using Enterprise ... Manager to change the service accounts. ... Change the SQL Server or SQL Server Agent Service ... >> Also we have given FULL CONTROL rights to the target directory. ...
    (microsoft.public.sqlserver.security)