sqlserver2000 forgot sa password solution--Modify SA password

There is a time useless sqlserver2000, today accidentally used, incredibly forgot the sa password, resulting in the program connection database failure, helpless, can only modify the existing password to solve. The following steps provide two ways to modify. One through the Enterprise Manager, one through the query parser.

1.

Use Enterprise Manager to modify an existing sqlserver2000 specified user password. Open SQL Server in the program group, locate Enterprise Manager, and run the.

2. Expand the SQL Server group to find the instance you want to modify. In this case there is only one instance of local, expand, find "security" expand, and then click "Login", you can see the right window has a list of users, we have to change the user "sa" password.

3.

Select the right mouse button for the user you want to modify, and select Properties from the pop-up menu to open the Properties window.

4.

In the pop-up Properties window, you can see the Password entry box and modify it directly. After the modification, OK, modify the password to complete.

5.

Another way is to use Query Analyzer. Or find the query parser in the program group and run it.

6.

When Query Analyzer is opened, the connection information is selected and Windows Authentication is selected here. Click OK to go to the main window.

7. Enter the following in the open input form: EXEC sp_password NULL, ' 1234 ', ' sa ', where ' 1234 ' is the password to be modified, replaced with the password you need, ' sa ' is the user and can be modified to your user. Click Execute (red circle in the picture).

8.

After execution, there will be a success prompt message. At this point, the password modification is complete.

sqlserver2000 forgot sa password solution--Modify SA password