Re: Sql server 2005 clustered service group

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

  • Cannot Use Non-Administrator Account to Start SQL Server and Force Encryption
    ... I changed the service account of a named instance (product ... a certificate from a Microsft Certificate Server ... the SQL Service. ... SQL Server could not spawn FRunCM thread. ...
    (microsoft.public.sqlserver.security)
  • Re: Restoring a SSP 3.0
    ... Also make sure this accounts are configured correctly in the IIS application ... Backup ContentDB in SQL Server using SQL Managagement Studio ... Restore the ContentDB from step 1 to new env. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Delegation problems
    ... I did a search for the SPN and it came back with two ... When the SQL server was initially setup (by a FORMER ... administrator) he used his account as the service account for SQL ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: local admin account password
    ... Subject: local admin account password ... > 4) Only use domain accounts so delete the local ones. ... > The DB file would be encrypted with EFS so only the limited user SQL ... > backup user can make a zip backup of the DB whenever it gets changed ...
    (Focus-Microsoft)
  • RE: local admin account password
    ... Say you have more then 1000 systems, how do you handle the local admin ... Only use domain accounts so delete the local ones. ... The DB file would be encrypted with EFS so only the limited user SQL ... There would be basically two stored procs, ...
    (Focus-Microsoft)
Loading