Security Best Practices tell us to remove BULITIN\Administrator from
SQL Server Logins. Is this also true in SQL Server 2000 Cluster.

Many Thanks
John

Yes, clustering does not change that.

Cheers,

Rod

"John" <johnx02 (AT) hotmail (DOT) com> wrote

but you do have to make sure you add the service account for sql server &
sql server agent, as well as the windows cluster service, as sysadmin role
members and valid logins to the server.

--
Richard Waymire, MCSE, MCDBA

This posting is provided "AS IS" with no warranties, and confers no rights.
"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:upYRYC$UEHA.2692 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

Some people take remove to mean deny access. Do not do this. It will cause
all logins who are members of the group to fail. Use the sp_revokelogin to
remove it.

Rand
This posting is provided "as is" with no warranties and confers no rights.