How can I put me back to sysadmin role?

Category: sql server security


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.