To use a Microsoft SQL Server source in a Qlik Replicate task, the user specified in the Microsoft SQL Server endpoint connection settings can be either of the following:
- A member of both the
db_ownerdatabase role and the
sysAdminfixed server role.
A member of the
db_ownerdatabase role but not a member of sysAdmin fixed server role. See also Setting up a non-sysadmin user in a standalone environment.