SQL Server Performance

BUILTINAdministrators

Discussion in 'SQL Server 2005 Clustering' started by gujsa01, Jun 15, 2007.

  1. gujsa01 New Member

    Hi,

    I have read a few posts on removing BUILTINAdministrators login within a clustering install
    and was wondering if the following is correct:

    1. Create a Windows account and make it a sysadmin.
    2. For Cluster Service Account, create this account within SQL Server and
    grant public access only. This is for the isAlive check to run @@Servername.
    3. Run xp_logininfo 'BUILTINAdministrators', 'members' to get the login list.

    Appreciate any help/advice.

    Thanks

  2. satya Moderator

  3. MohammedU New Member

    How to impede Windows NT administrators from administering a clustered instance of SQL Server

    http://support.microsoft.com/kb/263712


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  4. gujsa01 New Member

    Appreciate your help guys!!

Share This Page