Share via


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 FIMSyncAdmins security group.

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. In FIM Service base address:, type the base address of the FIM service, for example https://localhost:5725.

    Note

    This field is only available for the management agent for FIM Service.

  4. 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.

  5. 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.

  6. 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.

    Note

    Steps 4-6 do not apply to the management agent for FIM Service.

  7. In Authentication mode, select SQL authentication or Windows integrated authentication, and then type a user account, password, and logon domain.

Note

Configuring a management agent for import from a delta view has special requirements. For more information, see See Also.

Note

Configuring a management agent for import and export from a multi-value table has special requirements. For more information, see See Also.

Note

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.

Note

You can select only one table or view per management agent.

Note

You are not required to install FIM on the server that is running Microsoft SQL Server. You can install FIM and Microsoft SQL Server on different servers.

See Also

Concepts

Using the Management Agent for Microsoft SQL Server
Delta Views for Database Management Agents
Multi-Value Tables for Database Management Agents