Hey. I've 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've 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've to give to the cluster service account in SQL? I've 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.
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
|||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
sql
No comments:
Post a Comment