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
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
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: