How to recover SQL 2000 SA Password

Microsoft SQL Server 2000 is a full-featured relational database management system that offers a set of administrative tools to ease the burden of maintaining database development and administration. It operates in one of two modes of verification:. Windows Authentication Mode (default) or mixed mode

It is easier for one to set the SA password in SQL 2000. Just follow the steps below:

* 2 Expand Security, and then click Login.
* 3 In the details pane, right-click, and then click Properties.
* 4 In the Password box, type the new password.

client connection type determines the choice of mode. If all incoming clients support trusted connections, you can use the Windows Authentication mode. If some clients do not support trusted connections, you can select mixed mode.
If you forgot SA password, you'll need to use MS SQL Server Password Unlocker to reset the SA password SQL 2000. MS SQL Server Password Unlocker is a simple but powerful Reset software to reset SQL password including reset SA password and other user password. It provides an easy and safe way to reset SQL Server password for Microsoft SQL Server 2000/2005/2008 in a minute.
There is no need to reinstall MS SQL Server on the computer. Master.mdf file format is enough for you to recover SA password in SQL 2000
Steps to restore with the following:

* 2 Click the application icon to launch it.
* 3 Click Open to import the file master.mdf. All user name of your MS SQL Server will be displayed.
* 4 Select from the account, click the Change Password button to reset the password.
* 5 Enter a new password, and then click OK to complete the operation.

note. A method for restoring the SA password in SQL Server 2000 is generally applied when I can not login SQL Server 2000 Windows Authentication trick to forget the login password of the system administrator

SQL Forgot password? This paper introduces how to reset the lost password from SQL Server easily.