active\active cluster configuration, urgent

SQL Server

Tej62007


Hey. I have 2 nodes in this active\active cluster. Both of them have 20gb memory. Right now, both are configured to use 12gb each. Is that the right way to configure it I was thinking we'll have IO issues if we ever failed over to a server. I have to migrate to SQL 2005 and needed some help regarding using accounts.

Should I use the same account for the cluster service and the SQL Server/Agent service If not what are the permissions I have to give to the cluster service account in SQL I have a cluster with 2 nodes. What permissions should the SQL account be given on the box Should it be a local admin or when installing, I give it the account and let SQL worry about giving permissions to the box

Thank you.
Top

Re: active\active cluster configuration, urgent

Michael Hotek


The SQL Server service accounts should be different than your cluster administrator account. The cluster administrator account must be a member of the local administrator group on each node.

The service accounts for the SQL Server services should be regular user accounts on the machine. The setup process will assign permissions to the appropriate registry keys and directories. You will have to create groups in the domain in order to finish installing the clustered instance. The link below provides the details for this as well as covering a large number of other upgrade issues.

http://www.microsoft.com/downloads/details.aspx FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en





Top

Re: active\active cluster configuration, urgent

Tej


And how should the cluster Admin account be configured in SQL What are the right it should be given if I plan to not have Builtin admins any rights in SQL. Is it a good idea to remove Builtin Admins from SQL Thank you very much

Tej


Top
  • Index