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
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.
In Database, type the database name.
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.
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.
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.
In Authentication mode, select SQL authentication
or Windows integrated authentication, and then type a user
account, password, and logon domain.
Notes
Configuring a management agent for import from a delta view has
special requirements. For more information, see Related
Topics.
Configuring a management agent for import and export from a
multi-value table has special requirements. For more information,
see Related Topics.
For import mode, the user account provided must have read
access rights to the database table or view that you want to
synchronize. For export mode, the user account provided must have
write access (that is, insert, delete, and update) rights to the
database table or view that you want to synchronize.
You can select only one table or view per management
agent.
You are not required to install Microsoft Identity Integration Server 2003 on the server that is running Microsoft SQL
Server. You can install Microsoft Identity Integration Server 2003 and Microsoft SQL Server on different
servers.
