SQL Server password problem (original)

server|sqlserver| Problem | original
Issue 1, the system login password has been modified, causing SQL Server to fail to start.

This is because the SQL Server service automatically binds a system account when it is started, which typically occurs when the system account is logged on to the system other than the Administrator account because the default SQL Server does not specify an account number.

Solution: Right click on "My Computer", "Administration", "services and Applications", "Services", right-click "MSSQLServer", select "Properties", select "Local System Account" or select "This account", and enter a new password.

Question 2, set the sa password, but forgot? How to change it? How to change it? Always forget ... Alas

Solution: Use Enterprise Manager, open the server with System account, expand the directory tree "root/security" in turn (note: Not right click Root to choose "attribute" inside security!) , left-click Login, right-click "sa" to select Properties, see "Password"?? Enter a new password and enter the new password again in the confirmation window, OK.