Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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:

http://p2p.wrox.com/sql-server-2000/6725-forgot-sa-password-unable-change-help.html

http://www.sqlrecoverytool.com/how-to-reset-sql-password.html

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 answers, posting an answer now requires 10 reputation on this site.

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.