Solution for sqlserver2000 to forget the sa password -- change the sa password and sqlserver2000sa

Source: Internet
Author: User

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.



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.