Via Enterprise Manager:
- Log in via Enterprise Manager
- Expand the Security Folder and select the Logins icon.
- Logins will be displayed on the the right plane in alphabetical order.
- Double click your login.
- Type in new password in password box and click 'Ok.'
- You will then be asked to type old password and confirm new password.
Via Query:(This can be done by using Query Analyzer )
EXEC sp_password 'oldpassword', 'newpassword'
Caution: Changing your MS SQL password will break your application's database connection. Please be sure to update your connection string as well.