locked out of local SQL Server

• sqltung

  Hall of Fame

  Points: 3962

  More actions

  May 31, 2013 at 8:02 am

  #274386

  Somehow my active directory account disappeared over the weekend. After getting the account back (same name), I could not login to my local SQL Server (on my PC). It's 2008R2, and I'm using XP.

  No one knows the sa password, but I normally login using Windows Authentication.

  Do I need to reinstall, or is there any other way to get into it?

• Lowell

  SSC Guru

  Points: 323518

  More actions

  May 31, 2013 at 8:32 am

  #1620106

  here's a few different ways to recover access by adding yourself as a sysadmin:

  via powershell, which supports impersonation by a local admin:

  http://sqlblog.com/blogs/argenis_fernandez/archive/2011/07/10/think-your-windows-administrators-don-t-have-access-to-sql-server-2008-by-default-think-again.aspx

  via A Scheduled Task, which supports impersonation by a local admin:

  http://sev17.com/2011/10/22/gaining-sql-server-sysadmin-access/

  By Bringing the SQL instance up in single user mode, and adding yourself that way:

  http://beyondrelational.com/modules/2/blogs/115/posts/11143/how-to-access-a-newly-installed-sql-server-2008-r2-instance-if-you-do-not-know-the-login-and-passwor.aspx

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• sqltung

  Hall of Fame

  Points: 3962

  More actions

  May 31, 2013 at 8:35 am

  #1620109

  Lowell, thanks for the suggestions!