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


Sponsored



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.