MSSQL‎ > ‎

Password Recovery


MSSQL SA User Password Recovery


  1. stop the database instance and bring it back up in single user mode

    NET STOP MSSQLSERVER
    NET START MSSQLSERVER /m

  2. Either connect with enterprise manager (click cancel on login screen when explorer wants to connect) then click on New Query and login. You have to do this because only one connection is allowed when the server is in single user mode.
  3. Execute the following
    sp_password @new = 'new_password', @loginame = 'sa'
  4. Or instead of step 3, run the following to get a command line query interface from cmd:

    Osql –S yourservername –E
    1> EXEC sp_password NULL, ’yourpassword’, ’sa’
    2> GO

  5. Stop the instance and bring it back up in normal mode.


Comments