Associate a user without login to a login in SQL Server

Use the following query on the database of the user.

Alter User [UserName] with login = [loginname]