July 15, 2005 at 7:50 am
Just wanted to check with some vetrans on removing the builtin/administrator login SQL server on a cluster.
I understand that the cluster service needs to be there before I can remove this.
SQLSERVICE and AGENT both run on a separate domain account than the cluster service.
I also double checked to make sure i can login as SA.
Am i missing anything?
Thanks,
warren
July 15, 2005 at 8:05 am
As I remember it, you can not remove BUILTIN/Administrators login when you are using clustering.
-SQLBill
July 15, 2005 at 2:56 pm
A while back I supported several SQL Server clustered instances, and BUILITIN\Administrators was not present. Unfortunately, I did not build those boxes, so I don't know what the work-around is.
Philip
July 15, 2005 at 3:33 pm
You can remove BUILTIN\Administrators but before you do, make sure the SQL Server Service account and the Cluster service account have the ability to login and are members of the sysadmin fixed server role. More here:
SQL Server Security: Security Admins
K. Brian Kelley
@kbriankelley
July 18, 2005 at 11:54 am
It's fairly easy - but care is required - there are a number of ms articles
Microsoft Knowledge Base Article - 263712
don't have the exact link to hand as I save them off to KB.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply