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

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:

• Cumulative Update 6 for SQL Server 2017

• Cumulative update 8 for SQL Server 2016 SP1  

• Cumulative Update 8 for SQL Server 2016
• Cumulative Update 7 for SQL Server 2014 Service Pack 2

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.