How to change the password of a SQL Server login

How to change the password of a SQL Server login 

(Enterprise Manager)

Also read :How to restart an Interrupted Database Restore in SQL Server?

To change the password of a SQL Server login

1. Expand a server group, and then expand a server.
2. Expand Security, and then click Logins.
3. In the details pane, right-click the login to modify, and then click Properties.
4. In the Password box, on the General tab, enter a new password.
5. Confirm the password.

Follow the steps below to reset the "SA" password if you have forgotten what it was set to: 

Step 1: * Go to the server that SQL Server is running on. * Open Enterprise Manager(Start -> Programs -> Microsoft SQL Server) * Right click on the SQL Server and select "Edit SQL Server Registration Properties" * Select "Use Windows authentication" and select OK. 

Also read :SQL Query for Attaching databases in Post Office

Step 2: * Once connected, select Security * Right click on sa and select properties * Reset the password.