CDC for SQL2012

Must start SQL Agent Service first.

Could not update the metadata that indicates database TestDB is enabled for Change Data Capture. The failure occurred when executing the command 'SetCDCTracked(Value = 1)'. The error returned was 15404: 'Could not obtain information about Windows NT group/user 'Domain\user', error code 0x5.'. Use the action and error to determine the cause of the failure and resubmit the request.

USE TestDB
GO
EXEC sp_changedbowner 'sa'

 

 

 Also attached the operation steps as below:

EXECUTE sys.sp_cdc_enable_db

EXECUTE sys.sp_cdc_enable_table 'dbo', 't1', @role_name = NULL, @supports_net_changes =1;

EXEC sys.sp_cdc_generate_wrapper_function

grant select on fn_all_changes_dbo_t1  to User1
grant select on fn_net_changes_dbo_t1  to User1

select top 10 * from fn_all_changes_dbo_t1(null, null, 'all')
select top 10 * from fn_net_changes_dbo_t1(null, null, 'all')