Thanks, but the user is owner of a whole bunch of stuff. 

Someone told me to use

sp_change_users_login 'Auto_Fix', 'username', NULL, 'passwork'

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_8qzy.asp

It worked like a charm.  The user in the database and the SQL user are synched.