How can I put me back to sysadmin role?

Category: sql server security

Question

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.


SK

Replies

Olaf Helper on Wed, 15 May 2013 03:33:06


Hello,

Please have a look at TechNet: Connect to SQL Server When System Administrators Are Locked Out, how to solve this.