MSSQL login
Ref MSFT articles; KBA-01010 , http://support.microsoft.com/kb/274188/, How to move sql databases
Problem
MSSQL login broken when database restored from another server
Solution
Find the names of the orphaned users
In enterprise manager, open restored database
select users folder
look for users with no login name
Run this script for the orphanned user (you may have to create the user in enterprise manager>security 1st)
EXEC sp_change_users_login 'Auto_Fix', 'pubuser'
output when successful;
The row for user 'privuser' will be fixed by updating its login link to a login already in existence.
The number of orphaned users fixed by updating users was 1.
The number of orphaned users fixed by adding new logins and then updating users was 0.
Reset passwords if necessary
Additional Comments
Solution found in experts exchange;
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21497213.html?query=database+login&clearTAFilter=true