Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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

↑ Back to the top


Resolution

This fix is included in the following cumulative updates:

About SQL Server builds

Each new build for SQL Server 2016 contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest cumulative updates for SQL Server:

Latest cumulative update for SQL Server 2017

latest build for SQL Server 2016

latest cumulative updates for SQL Server 2014

SQL Server 2014

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

About cumulative updates for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were in the previous build. Check out the latest cumulative updates for SQL Server 2014.

↑ Back to the top


Status

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

↑ Back to the top


References

Learn about the terminology Microsoft uses to describe software updates.

↑ Back to the top


Keywords: kb, kbqfe, kbfix, kbnotautohotfix, kbexpertiseinter, kbsurveynew

↑ Back to the top

Article Info
Article ID : 4038932
Revision : 15
Created on : 4/9/2018
Published on : 4/19/2018
Exists online : False
Views : 404