Take sqlserver2008 as an example:
1. Log in to SQL Server Management Studio.
2. Click Security-Login.
3. Right-click the user name you want to change, and then click the Properties button.
4. The interface as shown in the figure appears. Change the password and confirm it, and then click OK.