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

Configuring Microsoft SQL Server

Configuring Microsoft SQL Server

After you install the components of
Identity Resolution
, you must configure Microsoft SQL Server so that
Identity Resolution
can communicate with it.
Informatica recommends that you must be an experienced DBA with appropriate authority to configure Microsoft SQL Server.
To configure Microsoft SQL Server for
Identity Resolution
, perform the following tasks:
  1. Create a user and grant the required permissions.
  2. Define an ODBC data source on the Search Server.
  3. Create tables and database objects by running the database scripts.
  4. Optionally, create Microsoft SQL API components.