Microsoft Identity Integration Server 2003 graphic

Connect to a Microsoft SQL Server database

For this procedure, in Management Agent Designer, on the Connect to Database page, you connect to a Microsoft SQL Server and provide information about the database to be synchronized. You must also provide a user account, password and logon domain to log on to the SQL Server database. The user account specified can use SQL Server authentication or Windows integrated authentication. The user account you specify must have at least read rights for the database. Each time the management agent is run, it uses this information to log on to the SQL Server database to read or write to the table or view you specify. To complete this procedure, you must be logged on as a member of the MIISAdmins security group.

This procedure applies to management agents for the following Microsoft Identity Integration Server 2003 editions:

Enterprise Edition Identity Integration Feature Pack for Active Directory
Microsoft SQL Server N\A

To connect to a Microsoft SQL Server database

  1. In Management Agent Designer, on the Connect to Database page, in Primary connection information, in Server, type the server name, alias, or IP address and port number.
  2. In Database, type the database name.
  3. If this management agent will perform a full import of data from a table or view, in Table/View, type the table or view name.
  4. If this management agent will perform a delta import of data from a specially configured delta view, in Optional connection information, in Delta view, type the name of the delta view. The delta view must use the primary table or view typed in the Table/View text box as a source.
  5. If this management agent will perform import of multi-value attributes from a specially configured multi-value table, in Optional connection information, in Multi-value table, type the name of the table. This table must use the table or view typed in the Table/View text box as a source.
  6. In Authentication mode, select SQL authentication or Windows integrated authentication, and then type a user account, password, and logon domain.

Notes

Related Topics

*

Using the management agent for Microsoft SQL Server

*

Delta views for database management agents

*

Multi-value tables for database management agents