291255 BUG: IsAlive Check Does Not Run Under the Context of the
http://support.microsoft.com/?id=291255

"service account that the cluster service runs under can log into SQL Server for the IsAlive check. "

263712 INF: How to Impede Windows NT Administrators from Administering a
http://support.microsoft.com/?id=263712

"1. Explicitly add the account that is being used for the Cluster Service as a SQL Server login. You must give this login the System
Administrator role. If full-text search is to be used on the cluster, you must add the [NT Authority\System] account to the server sysadmin
group. For example:

Grant [NT Authority\System] a logon to SQL Server:
EXEC sp_grantlogin [NT Authority\System]
Add that account to the sysadmins role:
EXEC sp_addsrvrolemember @loginame = [NT Authority\System]
, @rolename = 'sysadmin'

2. Remove the "BUILTIN\Administrators" login from SQL Server after you
install the virtual server."


Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks Cindy,
Any specific reason why does cluster service account
requires sysadmin rights on sql server2000.We have cluster
sql2000 servers running with just login for cluster
service account.Any drawback of using cluster service
account w/o sysadmin righs?We have already removed
builtin/Admin group from sql server.Also we are not using
FullText search.
Thanks Again.
--Jp
login the System
account to the server sysadmin