FIX: Change Data Capture functionality does not work in SQL Server

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer


After you enable change data capture for a SQL Server database, the Change Data Capture functionality might not work if one of the following conditions is true:

  • The database that is enabled for CDC is part of the Always On availability group.

  • SQL Server replication components are not installed on the server.

This issue may also affect SQL Server Integration Services (SSIS) packages that use the CDC flow components (CDC Source component) to extract changes from a CDC-enabled database.

For more information about this issue, see the following blog on the Microsoft Developer website:

CDC functionality may break after upgrading to the latest CU for SQL Server 2012, 2014 and 2016


This fix is included in the following cumulative updates:

SQL Server 2014

This issue is fixed in Cumulative Update 7 for SQL Server 2014 Service Pack 2.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology Microsoft uses to describe software updates.