Post reply

Windows Auth with no SysAdmin Users! HELP

  • March 1, 2012 at 4:29 am

    #256751

    Hi all,

    We have been having a AD clean up and someone has deleted the Windows Group with SysAdmin rights to a couple of SQL boxes. All of them are in Windows Authentication. And only had that 1 group as SysAdmins.

    Any ideas how i can put in a group with SysAdmins?

    Thanks

    S

  • March 1, 2012 at 5:04 am

    #1453553

    if none of the accounts can log in as a sysadmin then the only way would be to start SQL in single user mode.

    first ensure you can log on as an account which is a local administrator on the server, start sql in single user mode then anyone who is part of local admins gets sysadmin rights, so you can add a new account in and then restart sql in normal mode.

  • March 1, 2012 at 5:08 am

    #1453555

    ohh surprisingly simple!

    Thank I will give it a go now!

  • March 1, 2012 at 5:23 am

    #1453557

    There is no need to restart is single user mode, you run a scheduled task as nt authority\system.

    http://sev17.com/2011/10/gaining-sql-server-sysadmin-access/[/url]

  • March 1, 2012 at 5:25 am

    #1453560

    learn something new every day

  • March 1, 2012 at 6:50 am

    #1453587

    Roger Lindsay (3/1/2012)

    There is no need to restart is single user mode, you run a scheduled task as nt authority\system.

    http://sev17.com/2011/10/gaining-sql-server-sysadmin-access/[/url]

    I had not seen that technique, Roger.

    Thanks for the link!

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 1, 2012 at 7:28 am

    #1453611

    Used the psexec guide and worked a charm.. very cool to know..

    thanks for all the help

    S

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply