none
I forgot my SA password for my instance of SQL 2000

    Question

  • Hi all,

    I have SQL 2000 and I forgot my SA password and cannot login as administrator using windows authentication.

    Is there any way to reset SA password?

    "Mixed Mode" authentication is enabled.

    If I change authentication mode in register to Windows only and then after restarting SQL change it back to Mixed, will it reset SA password to "null"?

    Thanks in advance.

     

    Tuesday, September 05, 2006 11:42 PM

Answers

  •  

    If you log onto the machine with the Database server installed and use the local administrator account or a network administrator account you should be able to reset the password.

    Wednesday, September 06, 2006 12:07 AM
  • Just in addition to Glenns post and your qustion: It won´t reset the password to null with changing the authentication type back and forth. If you don´t have any GUI to administer your passwords you can use the procedure sp_password passing in a NULL for the old password parameter, as you don´t need the old if you are logged on as a user with sysadmin / securityadmin rights.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Wednesday, September 06, 2006 3:34 AM

All replies

  •  

    If you log onto the machine with the Database server installed and use the local administrator account or a network administrator account you should be able to reset the password.

    Wednesday, September 06, 2006 12:07 AM
  • Just in addition to Glenns post and your qustion: It won´t reset the password to null with changing the authentication type back and forth. If you don´t have any GUI to administer your passwords you can use the procedure sp_password passing in a NULL for the old password parameter, as you don´t need the old if you are logged on as a user with sysadmin / securityadmin rights.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Wednesday, September 06, 2006 3:34 AM
  • As I said before I can't login even with local Administrator. I don't know what is going on. It is so weird.
    Wednesday, September 06, 2006 5:01 PM
  •  

    Try

     

    sp_password NULL,NULL,'sa'

     

    Assuming you never created password at the first place. parameter 1 is Old password, parameters 2 is new password, parameter 3 is user.

    Monday, September 24, 2007 9:54 PM
  • Anubis7179,

    Did you resolve the login problem? I have one sql server MSDE 2000, I don't have sa password and I login sql box using local admin account, still cannot connect to the instance, the instance is running under "LocalSystem".

    Thanks,
    beijingwazi
    Tuesday, April 21, 2009 5:22 PM
  • you'll need another sql server instance & be able to stop the db & copy the master data /log file but try this: http://nick.kavadias.org/2009/04/re-setting-the-sa-password-without-admin-privileges/
    • Proposed as answer by Nick Kavadias Sunday, April 26, 2009 12:05 AM
    Wednesday, April 22, 2009 11:58 AM
  • Nick,

    Thank you very much for your reply. I believe your method will work. I just need to persuade bussiness users to give me some server downtime to do that.

    I will try.

    Beijingwazi

    Sunday, April 26, 2009 1:19 AM