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>


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


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

Publication Date:  2012-09-17 Views:  267 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
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
We can change the SA password of SQL Server database by network management system maintenance tools if the present server has installed VSM.