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.
