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.
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 🙂
Wonderful,
Worked a treat, was back as an admin withing a few seconds!
Many thanks…
That script worked perfectly for me…THANKS!!!!!!
Amazing script. Just stopped the instances and added the user as admin and then started again, everything works 🙂 Thanks a lot !!
Amazing script! Thank you so much!
Beautifully simple!
Thanks thats excellent. easy good fix.
Thank you very much for the script it works!
God Bless ^_^
I get the error verify the mssql$SQLExpress service exists, even though Services shows its there
Hi bj,
Please provide a more detailed description of what happened when you ran the script.
Thanks,
Ward.
One other idea: please run "sc query mssql$sqlexpress" at a command prompt, and paste the results into a comment on this blog.
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.
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 🙂
Wonderful! Thanks! You saved hours of work!
Can you reupload the script? I guess is offline now, thanks!
Thanks a ton !!! It worked for me 🙂
Guys this is JUST GOLD :D…..I am happy like anything
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.
saved me a lot of time! worked like a charm. Amazing!
The link to Ward's script no longer works. Help!
Please provide us with a working link to the script.
The link doesn't work anymore, please post a new one.
gist.github.com/…/1677788
I can confirm the github link above is the same script and that it does work properly.
Hi
The link to the code doesnot exist anymore. can you please post the new link
Hi,
The link to the script doesn't exist anymore. Can you please post a new one?
GitHub link works properly
gist.github.com/…/1677788