BULITIN\Administrator

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@.hotmail.com> wrote in message
news:a701f8e6.0406161039.6b7e9616@.posting.google.c om...
> 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
|||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@.die.spam.die.nw-america.com> wrote in
message news:upYRYC$UEHA.2692@.TK2MSFTNGP09.phx.gbl...
> Yes, clustering does not change that.
> Cheers,
> Rod
> "John" <johnx02@.hotmail.com> wrote in message
> news:a701f8e6.0406161039.6b7e9616@.posting.google.c om...
>
|||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.