Complete lock out from SQL Server 2008

• alexander.rista

  Newbie

  Points: 7

  More actions

  May 11, 2011 at 8:54 pm

  #238022

  SA account is locked out. Windows login was disabled for STIG requirements. (DOD)

  I tried starting SQL in single user mode

  1. Stopped all sql services.

  2. sqlservr.exe -m

  3. sqlcmd -E

  The account is disabled.

  Do I need to reinstall? Let me know.

  Thanks for the help.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  May 11, 2011 at 10:07 pm

  #1323467

  Try these steps from EvilDBA

  1. Lets assume you're local admin of server or domain admin.

  2. RDP to the server.

  3. On command prompt NET STOP MSSQLSERVER (stop sql server)

  4. On command prompt NET START MSSQLSERVER /m (start server in single user mode)

  5. Now login to SQL server.

  6. Created a new login on SQL server and make it as SYSADMIN.

  7. Exit from sql server.

  8. NET STOP MSSQLSERVER (stop sql server)

  9. NET START MSSQLSERVER (start sql server)

  Thank You,

  Best Regards,

  SQLBuddy.