Tuesday, February 14, 2012

builtin admin - OOOPS

Lets say a dba removes the builtin admin group from the sql server in haste.
They donâ't have any other logins with sysadmin rights, and they donâ't know
the SA password. How would they get sysadmin rights back?It would be difficult to start the services using some service account if there is no service
account with sysadmin privileges. For instance, Agent refuses to start unless it is sysadmin. Worst
case, you use LocalSystem as service account, then it is more difficult since you cannot use this
interactively. In that case, I guess you are in for a rebuild of the system databases.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:4ED73AA6-A4A1-452E-877B-2135C0804FC7@.microsoft.com...
> Lets say a dba removes the builtin admin group from the sql server in haste.
> They donâ't have any other logins with sysadmin rights, and they donâ't know
> the SA password. How would they get sysadmin rights back?

No comments:

Post a Comment