Required permissions
The user specified in the connector settings must have the following privileges on the source database:
Running with the db_owner role
If the user is a member of the db_owner database role, the following permissions must be granted:
-
On the master database:
- grant VIEW ANY DEFINITION
- grant VIEW SERVER STATE
-
On the MSDB database:
-
grant SELECT ON SYSJOBACTIVITY
-
grant SELECT ON SYSJOBS
-
Running without the db_owner role
If the user is not a member of the db_owner database role, the following permissions must be granted on the source database:
- grant VIEW DATABASE STATE
- grant SELECT
Information noteWhen running without the db_owner role, MS-CDC cannot be enabled automatically and must therefore be enabled manually. To prevent landing errors, you must also clear the Enable MS-CDC on all captured tables check box in the connection properties before running the task. For more information, see Microsoft SQL Server (Microsoft CDC based)