Orphaned SQL Users

When you restore a Microsoft SQL Server database to a different Server you will get Orphaned SQL Users. First, we need to find the orphan users. This will lists the orphaned users: EXEC sp_change_users_login ‘Report’ If you already have a user on the new server that corresponds to the database user, you can fix it …

Continue Reading