Knowledgebase
Command to reconnect user after restoring a database to a different server Print this Article
Connect to the restored database using Query Analyzer.
If you don't know which user's are missing:
To restore a known SQL user:
If you don't know which user's are missing:
EXEC sp_change_users_login 'Report'To restore a known SQL user:
EXEC sp_change_users_login 'Update_One', 'OldUserName', 'NewUserName'
