Solution for sqlserver2000 to forget the sa password -- change the sa password and sqlserver2000sa
I haven't used sqlserver2000 for a while. I accidentally used it today and forgot the sa password. As a result, the program failed to connect to the database. Instead, I had to modify the existing password to solve the problem. The following steps provide two modification methods. One is through the Enterprise Manager and the other is through the query analyzer.
1,
Use Enterprise Manager to modify the User Password specified by sqlserver2000. Open sqlserver in the program group, find the Enterprise Manager, and run ..
2. Expand the sqlserver group and find the instance to be modified. In this example, there is only one instance, expand, find "security", and click "Log On". the user list is displayed in the window on the right, we want to change the user's "sa" password.
3,
Right-click the user you want to modify and select "properties" from the shortcut menu to open the Properties window.
4,
In the pop-up attribute window, you can see the password input box. Modify it directly. After modification, click OK. The password is changed.
5,
Another method is to use the query analyzer. Or find the query analyzer in the program group and run it.
6,
After opening the query analyzer, you will first select the connection information. here you need to select "windows Authentication ". Click OK to enter the main window.
7. Enter the following content in the open input form: EXEC sp_password NULL, '123456', 'sa ', where '123456' is the password to be modified, replace it with the password you need. 'sa 'is a user and can be changed to your user. Click execute (red circle in the figure ).
8,
A message indicating successful execution is displayed. So far, the password has been modified.