If SQL Server 2005, use SQL Server Configuration Manager to make the change. You'll need to change the password on the domain first.
Also, if you have anywhere else where that username is used (like other SQL Servers), they'll all need to change at the same time.
K. Brian Kelley
@kbriankelley