Using Db Maint, Working with…

Map Orphaned Users

To open this dialog, right-click a database, select “Operations”, “Map orphaned users”. This dialog is available on SQL Server 7.0 and 2000.

The dialog allows you to map orphaned users to the desired SQL Server login in the master database. A user becomes orphaned when you restore a backup of a database onto another SQL Server. For SQL Server logins, a SID number is generated and this SID number is what ties a user to the login. A login with the same name will not have the same SID number in two SQL Servers.

Map single users

The dialog is designed so that you map users until there are no more orphaned users left. To map a single user, select the user in the left drop-down box, the login in the right drop-down box and press “Map selected user to selected login”.

Remove a user

If you want to remove a user, select “Delete selected user”.

Add a login

If there is no login available for a user, you can create a login by selecting “Add SQL Server login”.

Auto-map several users

You can also map all users for which there exist a login with the same name. This is a very convenient way to quickly map many users. Select “Map all users which has a corresponding login name”.