How to take ownership of your local SQL Server 2008 Express

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