Home Forums SQL Server 2005 Administering how to disable windows authentication in sql server 2005 Active active cluster RE: how to disable windows authentication in sql server 2005 Active active cluster

  • Schadenfreude-Mei (11/25/2009)


    Why exactly are you trying to do this? It is a bit concerning that you dont have access to delete users but are talking about disabling them.

    You also ask about adding users which you should know how to do if you are doing stuff like this. But want to add the type of user (AD) that you say you want to disable; and are now talking about cluster service users.....

    Be very careful you know what you are doing and have authorisation otherwise your future might not be so rosey.

    What exactly do you want to accomplish and why?

    my interpretation is that his/her question is clumsy formulated and he/she wants to know if it is possible to keep a sql server in a windows cluster environment clean from windows system administrators and keep it for dba's "only". i'll read the proposed solution link later but the issue i had (and perhaps is solved in the ms article) is that the health check needs in the standard setup sysadmin rights. and the health check is done with an account to which system administrators have access.