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 removedAnonymous
May 08, 2012
I get the error verify the mssql$SQLExpress service exists, even though Services shows its thereAnonymous
May 08, 2012
The comment has been removedAnonymous
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 anythingAnonymous
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/.../1677788Anonymous
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 linkAnonymous
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