Question regarding configuration of an Active/Active cluster

Hey. I've a Active\Active with SQL 2000 on the nodes right now. 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.

Tej,

According to MS:

- You should have different accounts for the cluster and SQl. Reason for this is that if the cluster account password changes, it does not affect SQL.

- You should create these account as normal domain user accoounts , but give them admin privileges on the SQL servers. When installing/configuring SQl and cluster services, these accounts will be given the correct permissions.

Check out this document

www.windowscluster.com/msdocs/confclus.doc