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

Publication Date:  2012-09-17 Views:  126 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