Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Installing Identity Resolution
  4. Post-Installation Tasks
  5. Troubleshooting
  6. Upgrading Identity Resolution
  7. Uninstalling Identity Resolution

Installation and Configuration Guide

Installation and Configuration Guide

Step 1. Create a User

Step 1. Create a User

Create a user that you can use to create and access the
Identity Resolution
tables and database objects. The user must not be a database owner (dbo). A database owner is a member of the
sysadmin
fixed server role. If a member of the
sysadmin
fixed server role creates an object, the object belongs to dbo, not to the member. In this case,
Identity Resolution
cannot identify the database objects that the user creates. You must add the user to the
db_ddladmin
fixed database role to create triggers on the USTs.
The following table describes the fixed database roles to which you must add the user that you create:
Database Type
Fixed Database Role
Source database without synchronization
db_datareader
Target database without synchronization
db_datareader
db_datawriter
db_ddladmin
Source database with synchronization
db_datareader
db_datawriter
db_ddladmin
Target database with synchronization
db_datareader
db_datawriter
db_ddladmin