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

Se aplică la: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

Symptoms


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

Resolution


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.

Status


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

References


Learn about the terminology Microsoft uses to describe software updates.