SQL Server Performance Forum – Threads Archive

BUILTINAdministrators

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

---

Seehttp://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritysecurityadmins.asp fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

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.

---

Appreciate your help guys!!

---

]]>