Re: Sql server 2005 clustered service group

I always do this as part of cluster setup (prepoulate the groups with the
service accounts). The install never seems to be able to do this in our
environment and prepopulating always works no problem.

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips


"Jason" <Jason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C594D91-AA5C-4260-BD6A-1B6E04768414@xxxxxxxxxxxxxxxx
that is what i did, and i was able to get through the installaion, but i
was
just wondering if that will cause any unforeseen issues.

"Tom Moreau" wrote:

Can you have the domain admin add the groups manually? I know it's a
PITA
but they did things differently in SQL 2005 than they did in SQL 2000.

--
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:82348410-D501-4A2B-A3BE-18D6DFC6DBE3@xxxxxxxxxxxxxxxx
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: Changing Windows Domain
    ... I take it your cluster & SQL ... > service accounts are already in the local administrators group on each node. ... > MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Sql server 2005 clustered service group
    ... administrator for the names of existing domain groups, ... The account under which SQL Server Setup is running must have privileges to ... 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: Sql server 2005 clustered service group
    ... Jasper Smith (SQL Server MVP) ... administrator for the names of existing domain groups, ... add accounts to the domain groups. ... needs rights to add the service accounts to the domain group ...
    (microsoft.public.sqlserver.setup)
  • 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: 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)