Permissions issue enabling MS-CDC on Azure SQL source

raffaelec — Tue, 04 Nov 2025 22:26:31 GMT

Hello,

I’m configuring a Log Stream replication task in Qlik Replicate that uses a Microsoft Azure SQL (MS-CDC) source. According to the official documentation for the latest release, it should be possible to run CDC without requiring the db_owner role: https://help.qlik.com/en-US/replicate/May2025/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/azremscdc-SQLServerDBSource-security.htm#ar_sqlserverds_1727505754_1656303.

Now, a user account has been created for Qlik Replicate on the Microsoft Azure SQL (MS-CDC) source without the db_owner role. When I start the Log Stream task, replication is suspended because the Qlik Replicate user doesn’t have sufficient privileges to enable CDC on the tables. Specifically, the following error is returned:

“SQL_ERROR SqlState: 42000 NativeError: 22904

Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Caller is not authorized to initiate the requested action. DBO privileges are required.

Line: 1 Column: -1

Failed (retcode -1) to execute statement:

EXEC sys.sp_cdc_enable_table @Source_schema=N'dbo', @Source_name=N'table_name', @role_name=NULL”.

The DBA indicated that it’s not possible to grant permission to execute this statement to the Qlik Replicate user without assigning the db_owner role.

When I try disabling the “Enable MS-CDC on all captured tables” option in the source endpoint instead, the replication of the tables is again suspended, showing the following message: “Data changes of table 'table_name' will not be captured because it is not enabled for MS-CDC, and Replicate is not set to enable this option automatically”.

My questions are

Is there any workaround that would allow a Qlik Replicate user without the db_owner role to enable CDC on the tables?
If the Qlik Replicate user doesn’t have the db_owner role, is it mandatory for another user with db_owner privileges to execute the EXEC sys.sp_cdc_enable_table command on the tables to be captured?

Thank you very much in advance for your help.

Best regards

Re: Permissions issue enabling MS-CDC on Azure SQL source

OritA — Thu, 06 Nov 2025 09:14:50 GMT

Hi,

As stated in the Replicate users guide under MS-CSC limitation section (see link below) :
"

When running without the db_owner role, the following limitations apply:

Capture of DDLs is not supported. To prevent replication errors, you must clear the Capture DDL events check box in the endpoint settings' Advanced tab before running the task.
MS-CDC cannot be enabled automatically and should therefore be enabled manually. To prevent replication errors, you must also clear the Enable MS-CDC on all captured tables check box in the endpoint settings' Advanced tab before running the task."

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/MicrosoftSQLServer-MSCDC/MicrosoftSQLServer-MSCDC-limitations.htm

So in your case after you enable the MS-CDC manually on your tables the task should run without any issues. IF you still encounter problems please open a Salesforce case and attach to it the task diagnostic package.

Regards,

Orit

topic Re: Permissions issue enabling MS-CDC on Azure SQL source in Qlik Replicate

Permissions issue enabling MS-CDC on Azure SQL source

Re: Permissions issue enabling MS-CDC on Azure SQL source