From time to time I have run into the annoying issue of orphaned SQL Server database users and decided to pass on some useful information on how to resolve this situation. The most common operation that will result in one or more orphaned database users is performing a database restore from a backup file to [...]