How to take ownership of your local SQL Server 2008 Express



Comments (26)

  1. Glenn says:

    Wonderful,

    Worked a treat, was back as an admin withing a few seconds!

    Many thanks…

  2. Patrick says:

    That script worked perfectly for me…THANKS!!!!!!

  3. Siddarth says:

    Amazing script. Just stopped the instances and added the user as admin and then started again, everything works 🙂 Thanks a lot !!

  4. Stijn Hoste says:

    Amazing script! Thank you so much!

  5. Michael says:

    Beautifully simple!

  6. rama charan says:

    Thanks thats excellent.  easy good fix.

  7. Reimar23 says:

    Thank you very much for the script it works!

    God Bless ^_^

  8. bj says:

    I get the error verify the mssql$SQLExpress service exists, even though Services shows its there

  9. wardbeattie@hotmail.com says:

    Hi bj,

    Please provide a more detailed description of what happened when you ran the script.

    Thanks,

    Ward.

  10. wardbeattie@hotmail.com says:

    One other idea: please run "sc query mssql$sqlexpress" at a command prompt, and paste the results into a comment on this blog.

  11. Could we try "PUT THE GD SA CONFIG TOOL BACK WHERE IT WAS" says:

    That would fix the problem, too, since you can add local administrators from the SA config tool.  You know…. what we like to call "the right way" to do things.

  12. Ole-Kristian Sunnarvik says:

    Great, finally. I moved my user from local user to AD user after installing VS, was really stuck with the permissions in SQL, and this finally solved it. Thanks a lot 🙂

  13. Michael says:

    Wonderful! Thanks! You saved hours of work!

  14. Oscar says:

    Can you reupload the script? I guess is offline now, thanks!

  15. Niti says:

    Thanks a ton !!! It worked for me 🙂

  16. vikash.kumar.mca@gmail.com says:

    Guys this is JUST GOLD :D…..I am happy like anything

  17. Abhijit says:

    I wish I had found this sooner. Could have saved me tons of time. I uninstalled sqlserver express from my desktop. Now planning to re-install it.

  18. Leslie says:

    saved me a lot of time! worked like a charm. Amazing!

  19. Gary says:

    The link to Ward's script no longer works.  Help!

  20. Dimitar Dimitrov says:

    Please provide us with a working link to the script.

  21. Taka says:

    The link doesn't work anymore, please post a new one.

  22. Is this the same? found it on Github Gists says:

    gist.github.com/…/1677788

  23. Mac says:

    I can confirm the github link above is the same script and that it does work properly.

  24. Vishal says:

    Hi

    The link to the code doesnot exist anymore.  can you please post the new link

  25. James Kim says:

    Hi,

    The link to the script doesn't exist anymore. Can you please post a new one?

  26. Palak mevada says:

    GitHub link works properly

    gist.github.com/…/1677788