This section describes how to create or modify a connection to Microsoft SQL Server so that Synchronization Service could work with data in that data system.
To create a connection to Microsoft SQL Server, use the Microsoft SQL Server Connector included by default in the Active Roles Synchronization Service.
The Microsoft SQL Server Connector supports the following features:
Feature |
Supported |
Bidirectional synchronization Specifies whether you can both read and write data in the connected data system. |
Yes |
Delta processing mode Specifies whether the connection can process only the data that has changed in the connected data system since the last synchronization operation. This reduces the overall synchronization duration. |
No |
Password synchronization Specifies whether you can synchronize user passwords from an Active Directory (AD) domain to the connected data system. |
Yes |