February 21, 2007 at 12:35 pm
I will appreciate if some one can explain me what is the use of this account = Builtin\Adminstrator in SQL Server& impact of removing this account\ID. any link or info will be appreciated.thank you
February 21, 2007 at 1:21 pm
Builtin\Adminstrator is the group of local administrators of the server and accounts like local system / local service.
If you remove it, be sure you'r running the sqlserver service using a windows account. Make it the service account before you try to remove Builtin\Adminstrator.
Also be sure noone is using his server-local-privilages to run an application at uses sqlserver. (e.g. (romote) connecting using win-authentication and being member of yourserver\administrators-group)
We always remove Builtin\Adminstrator after modifying the service account and alowing the dba-group privilages to the sqlserver.
I think there are articles and threads at SSC. Search for 'Builtin\Adminstrator'
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 21, 2007 at 1:29 pm
GOOD ADVICE:
Before you remove Builtin\Administrator, create a SQL Server authenication login for yourself. Make its default database Master and give it System Administrator role.
That way you can ensure you will still be able to log into SQL Server no matter what else happens. (As long as the SQL services work).
-SQLBill
February 22, 2007 at 7:09 pm
As a failsafe do not remove the login just deny access. Also, if you are using MOM,you will need to explicitly grant the MOM action account sysadmin.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
February 23, 2007 at 12:17 am
How to impede Windows NT administrators from administering a clustered instance of SQL Server
http://support.microsoft.com/?id=263712
MohammedU
Microsoft SQL Server MVP
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply