No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade
MENU

FAQ-How to change the super user’s SA password of SQL Server database?

Publication Date:  2012-09-17 Views:  266 Downloads:  0
Issue Description
What should we do if we forget to set the SA user password or need to change the password when we install the SQL Server 2000?
Alarm Information
None.
Handling Process
1 Choose “start>program>Microsoft SQL Server>enterprise management” menu option, it will appear “SQL Server Enterprise Manager” window;
2 Open out the database server group, database server and security node of the left navigation tree in turn, then choose “login”;
3 Double click the “SA” user on the right of the window, change the SA user password at the pop-up dialogue box, and then click “OK”;
4 Input new password at the pop-up confirm password dialogue box, click “OK”.
Root Cause
None.
Suggestions
We can change the SA password of SQL Server database by network management system maintenance tools if the present server has installed VSM.

END

Contribute Articles
Huawei Enterprise APP

Copyright © 2018 Huawei Technologies Co., Ltd. All rights reserved.