Share via

How to take ownership of your local SQL Server 2008 Express

  • Article

Comments

  • Anonymous
    May 04, 2011
    Wonderful, Worked a treat, was back as an admin withing a few seconds! Many thanks...

  • Anonymous
    August 17, 2011
    That script worked perfectly for me...THANKS!!!!!!

  • Anonymous
    January 11, 2012
    Amazing script. Just stopped the instances and added the user as admin and then started again, everything works :) Thanks a lot !!

  • Anonymous
    February 22, 2012
    Amazing script! Thank you so much!

  • Anonymous
    February 28, 2012
    Beautifully simple!

  • Anonymous
    March 19, 2012
    Thanks thats excellent.  easy good fix.

  • Anonymous
    March 29, 2012
    The comment has been removed

  • Anonymous
    May 08, 2012
    I get the error verify the mssql$SQLExpress service exists, even though Services shows its there

  • Anonymous
    May 08, 2012
    The comment has been removed

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

  • Anonymous
    June 07, 2012
    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.

  • Anonymous
    July 21, 2012
    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 :-)

  • Anonymous
    August 30, 2012
    Wonderful! Thanks! You saved hours of work!

  • Anonymous
    September 04, 2013
    Can you reupload the script? I guess is offline now, thanks!

  • Anonymous
    November 11, 2013
    Thanks a ton !!! It worked for me :)

  • Anonymous
    February 15, 2014
    Guys this is JUST GOLD :D.....I am happy like anything

  • Anonymous
    February 20, 2014
    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.

  • Anonymous
    March 12, 2014
    saved me a lot of time! worked like a charm. Amazing!

  • Anonymous
    May 22, 2014
    The link to Ward's script no longer works.  Help!

  • Anonymous
    May 22, 2014
    Please provide us with a working link to the script.

  • Anonymous
    June 04, 2014
    The link doesn't work anymore, please post a new one.

  • Anonymous
    June 07, 2014
    gist.github.com/.../1677788

  • Anonymous
    June 16, 2014
    I can confirm the github link above is the same script and that it does work properly.

  • Anonymous
    September 08, 2014
    Hi The link to the code doesnot exist anymore.  can you please post the new link

  • Anonymous
    March 26, 2015
    Hi, The link to the script doesn't exist anymore. Can you please post a new one?

  • Anonymous
    August 17, 2015
    GitHub link works properly gist.github.com/.../1677788