Required permissions

To use Microsoft SQL Server as a source in a replication task, the user specified in the Microsoft SQL Server endpoint connection settings must be one of the following:

• A member of both the db_owner database role and the sysAdmin fixed server role.

• A member of the db_owner database role but not a member of sysAdmin fixed server role. See also Setting up a non-sysadmin user in a standalone environment.