Management Agent for SQL Server

Applies To: Windows Server 2003 with SP1

Use the management agent for Microsoft SQL Server to synchronize with Microsoft SQL Server 7.0, SQL Server 2000 or SQL Server 2005.


If available in Identity Integration Feature Pack for Microsoft® Windows Server™ Active Directory® (IIFP)


Management agent type


Supported connected data source versions

  • SQL Server 7.0

  • SQL Server 2000

  • SQL Server 2005

MIIS 2003 features supported

  • Password management by using password extension

  • Full import

  • Delta import

  • Export

Schema Information

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.


  • 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."

  • SQL Server 2005 adds the following new data types:

    SQL Server data type Maps to ILM 2007 data type:


    Non-indexable string


    Non-indexable string


    Non-indexable string


    Non-indexable Binary

    User-Defined Type (UDT)

    Not supported by the management agent for Microsoft SQL Server


None of the new SQL Server data types may be used as anchor attributes.

See Also


Management Agents in MIIS 2003