User profiles can only be mapped to an existing database user
ID. When that database user ID is removed from the database, all
integrated login mappings based on that database user ID are automatically
removed.
- Connect to a database as a user with DBA authority.
- Right-click the Login Mappings folder for the database,
and select Login Mapping. The Integrated Login wizard is displayed.
- On the first page of the wizard, enter the name of the
system (computer) user for whom the integrated login is to be created.
You can either select a name from the list or enter a name.
Also, select the database user ID this user maps to. The wizard
displays the available database users. You must select one of these.
You cannot add a new database user ID.
- Follow the remaining instructions in the Wizard.