How to connect an existing SQL Server login to an existing SQL Server database user of same name

Question

Is there a SQL Server command to connect a user of a single database to a login for the database server of the same name?

here's the example:

Database Server - Default Instance Database: TestDB

Server Login - TestUser Existing user on TestDB - TestUser

If I try to make the TestUser login a user of the TestDB database, the "User, group, or role" already exists.

Does anybody know of an easy way to assign the user to the login?

Answer 1

I think its sp_change_users_login its been a little while but used to do that when detaching and reataching databases

http://msdn.microsoft.com/en-us/library/ms174378.aspx

Answer 2

I've used the sp_change_users_login procedure to accomplish, I think, that scenario.

Answer 3

The new way is to use ALTER USER

ALTER USER OrphanUser WITH LOGIN = correctedLoginName