BuiltIN Administrator Account

  • We typically revoke the sysadmin role from this account on our instances but I'm running into a problem doing this when I have a Cluster.

    It appears that the cluster services require this role.

    Has anyone determined a way around this?

    thks

     

     

     

  • Nope, clustering does require the Builtin/Admin role. I haven't seen any 'fix' or 'work around' for this.

    -SQLBill

  • Grant sa  access to the cluster account and then revoke builtin\admin role.  Below is the KB article.

    http://support.microsoft.com/?id=263712

  • Don't forget the NT Authority\System login if Full-Text Indexing is installed. It's at the bottom of that article.

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply