Re: Sql server 2005 clustered service group

yeah, and yeah
but my account doesn't have domain rights.

this is from BOL explaining it

Options
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.



"Tom Moreau" wrote:

Did the service account already exist? Were you logged onto the server with
an account that was an administrator on both boxes?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Jason" <Jason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:10E4AF03-B264-4A02-A4BF-B5D472606EB2@xxxxxxxxxxxxxxxx
I didn't save the error but it it said the account that is running the setup
needs rights to add the service accounts to the domain group

"Tom Moreau" wrote:

You're not adding the account to a domain group. It's being added to a
local group. You need domain accounts since the two machines have to talk
to each other.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Jason" <Jason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E09B44D9-D704-41DD-8822-18051DE84DFE@xxxxxxxxxxxxxxxx
Sql server 2005 clustered service group

I see with installing SS2005 cluster if forces me to use domain accounts
and
add the service account to them as part of the cluster installation.

1. What is the purpose of this?
2. At the company I currently work, getting domain rights for a DBA is a
huge challenge. Is there any problem with having the domain admins add
the
service account to the domain group, instead of letting the SQL Server
cluster installation do it?




.

Relevant Pages

  • 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: Domain Groups For Clustering Service ???? SQL Server 2005
    ... I made three domain groups named as SQLUsers,AgentUsers,FTUsers ... and then put the Service Account named as SQLService and administrator ... > Jasper Smith (SQL Server MVP) ... >> add accounts to the domain groups. ...
    (microsoft.public.sqlserver.clustering)
  • Re: 2-node cluster wont stop sqlservr.exe during user-initiated f
    ... It is the only supported way to change service accounts for SQL ... Microsoft SQL Server MVP ... > I'm concerned that the roaming profiles required for cluster access to ... Go ahead and switch accounts, save, switch back, save again and ...
    (microsoft.public.sqlserver.clustering)
  • Re: Sql server 2005 clustered service group
    ... I always do this as part of cluster setup (prepoulate the groups with the ... Jasper Smith (SQL Server MVP) ... add accounts to the domain groups. ... needs rights to add the service accounts to the domain group ...
    (microsoft.public.sqlserver.setup)