ace_hk on Wed, 15 May 2013 01:28:46
While testing some test scenarios, I accidentally removed myself from sysadmin role and I can't add myself back again.
I am the local admin (my dev server) where SQL 2008 R2 is installed. No SA user access, unfortunately.
Any suggestions? Thanks.
Olaf Helper on Wed, 15 May 2013 03:33:06
Please have a look at TechNet: Connect to SQL Server When System Administrators Are Locked Out, how to solve this.