Microsoft Identity Integration Server 2003 graphic

Using the management agent for Microsoft SQL Server

By using the management agent for Microsoft SQL Server, you can synchronize with Microsoft SQL Server 7.0 or SQL Server 2000.

The following Microsoft Identity Integration Server 2003 versions support this management agent:

Microsoft Identity Integration Server 2003, Enterprise Edition

Connected data source support

SQL Server 7.0
SQL Server 2000

Management agent type

This is a call-based management agent.

Schema

The schema is generated based on the source database table definition. When you refresh the schema for this management agent, the connected data source schema is rediscovered, the current management agent schema is updated, and then Management Agent Designer starts. In Management Agent Designer, you can correct any inconsistencies introduced by the updated schema, such as deleted object types or deleted attributes.

Remarks

If you want to use Microsoft Identity Integration Server 2003 to synchronize multiple SQL Server 2000 tables or views, create a management agent for each table or view.
One object type is created in the connector space for each table or view.
You are not required to install Microsoft Identity Integration Server 2003 on the server running SQL Server.
Microsoft Identity Integration Server 2003 does not support table names enclosed in quotations. You will receive the following connection error: "Failed to retrieve the database table schema. Unspecified error."
This management agent supports password management. For more information, see Related Topics.