Clustering Domain accounts

Question

Clustering Domain accounts

klnsuddu

SSCertifiable

Points: 5836
More actions
April 16, 2009 at 11:42 am

#133175

Hi,
We are installing Sql server 2005 in A/P cluster setup. In This,
1.The service Account page, I entered the below:(See attachement1)
user: ABC
Password: xxxx
Domain: XYZ
Is this account for login to the server? or the sqlserver,sqlagent,fulltext search will run with this account?
2.What will be the 3 accounts should be given in attachment2?
Can we use the same account used in above step? ie ABC\XYZ
And in development,I followed as below.
1.Iam using 'sqladmin' to login to the Box.
2.In the Service Account page, Iam giving,
User: dbadmin
pswd: xxxxx
Domain: XYZ
but Service account page says,this account will be used to login. that means I shoud enter sqladmin here instead of dbadmin right?
3.In Domain Groups for clustered services, Iam using diffrent account like below:
SQL Sevrer: ABC\dbasql
SQL SevrerAget: ABC\dbasql
FulltextSearch: ABC\dbasql
But even if I given ABC\dbasql in above, all the 3 service are running under 'XYZ\dbadmin' which is given in step1
so what is the difference. Iam so confused with this accounts.Please clarify me?
and at the end will sql server, sqlagent,fulltext search will run under
1.the account we choose in Service Account page? OR
2.the account we choose in Domain Groups for clustered services?
many thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 1

The services will be run by the individual service accounts. However, a domain groups that contains these domain accounts that will run the various services will need to be created prior to the install. These groups will be given administrative rights within the SQL Server instance, so they should contain only the domain account that the SQL Server instance will run under.

Three domain groups are needed; however, if the full text service, SQL Server Agent service, and SQL Server service all run under the same domain account, only one domain group is needed.

klnsuddu SSCertifiable Points: 5836 More actions · Answer 2

Could you please clarify me the below

and at the end will sql server, sqlagent,fulltext search will run under

1.the account we choose in Service Account page? OR

2.the account we choose in Domain Groups for clustered services?

or do we need to choose same account in both places?

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 3

and at the end will sql server, sqlagent,fulltext search will run under
1.the account we choose in Service Account page? OR
2.the account we choose in Domain Groups for clustered services?
or do we need to choose same account in both places?

Each of these services will run with the domain account (not domain group) you specify during the setup. The domain groups are apparently used for entitlement purposes.

As mentioned above, if you do end up using different domain accounts for each service, make sure you have different domain groups created and their respective service accounts added to those domain groups.

I haven't felt the need to separate out the service accounts for each service. However, there may be others out there who may feel the need to use separate accounts. That will definitely be a decision you need to make for your environment.

HTH