**Let's assume the database name is Test , then run:
===
use Test
exec sp_Change_users_login 'report'
==
The result will give you the list of the users in that database which have conflict with the login IDs.(Of course, you have to set up the logins in the security setting before you run that stored procedure)
** Let's assume one of the user is called usr_Test, then run
===
use test
exec sp_change_users_login 'update_one','usr_Test','usr_Test'
===
The link between the user and the login will be reestablished. run the sp for each of the users in that list.
Good luck!
===
use Test
exec sp_Change_users_login 'report'
==
The result will give you the list of the users in that database which have conflict with the login IDs.(Of course, you have to set up the logins in the security setting before you run that stored procedure)
** Let's assume one of the user is called usr_Test, then run
===
use test
exec sp_change_users_login 'update_one','usr_Test','usr_Test'
===
The link between the user and the login will be reestablished. run the sp for each of the users in that list.
Good luck!