How to change database user password
Created: 16 Jul 2009 • Updated: 21 May 2010
I need to change the database user password, my database is stored in a SQL 2005 Server.
The username that i want to change is in Admin > Servers > Database Server - Database User:
Quick Look Solution
SQL StudioYou can reset this password from SQL Management studio.
Once you open it --Under sem5 ( or whatevr the name of the databse is ) Login --you will find that user just go to properties of the user and reset it.
This is the closest article i found
like shown in the link do the same for your User account. and SA.