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
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:
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?