Re: Sql server 2005 clustered service group

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: Upgrade from 2005 to 2008: Invalid Credentials
    ... it seems that this issue was related to NETWORK SERVICE account for SSIS service could not be validated on DC. ... Please first go to your Services pane, double click your SQL Server Integration Services, switch to the Log On tab to check if the service account is NETWORK SERVICE account. ... Install SQL Server 2008 from the Command Prompt ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: SPN Requirement
    ... The service account for SQL Server needs to be a domain ... account to allow Write Public Information rights but I'd ... The SQL Network Interface library could not register the Service Principal ... Name for the SQL Server service. ...
    (microsoft.public.sqlserver.security)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I granted the SQL Server Service Account "Full Control" over ... the Snapshot Folder and the job has been running successfully ever since. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)
  • Re: xp_cmdshell failed to execute because current security context
    ... INFO: databasename: xp_cmdshell failed to execute because ... SQL Server running under has appropriate privilege. ... Server service account does not have all the relevant permissions not the sql ... ontario, canada ...
    (microsoft.public.sqlserver.server)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I am guessing that the SQL Server Agent service account is not what ... rights to remove folders under P:\ReplData. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)