Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I had forgotten my SQL server 2000 sa username password and now i am not able to connect to it. previously i had disabled windows authentication and had only username sa.

Now I ant to recover / reset my password of sa.. How can i do that

share|improve this question

The best way is to simply reset the password by connecting with a domain/local admin (so you may need help from your system administrators), but this only works if SQL Server was set up to allow local admins (these are now left off the default admin group during setup).

If you can't use this or other existing methods to recover / reset the SA password, some of which are explained here:

You can check here:

share|improve this answer
I tried to follow the instruction at the first link.. it says login failed for server\administrator... while trying to expand the server at enterprise manager, is there any other tryouts.. – Prem_Kumar_S Mar 20 '13 at 12:26
What about the second link??? you can check there also there is some tryout available on that very page. – user165572 Mar 20 '13 at 12:38

protected by Iain Mar 28 '13 at 7:57

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.