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:
This fix is included in the following cumulative updates:
- 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.