This database (mydb) does not have CDC enabled

Root cause

SQL Server CDC (Change Data Capture) feature is not enabled at the database level. CDC is a SQL Server Agent feature and must be enabled separately from Debezium.

How to fix

1. Enable CDC at database level:
   USE [mydb]; EXEC sys.sp_cdc_enable_db;
2. Enable CDC per table:
   EXEC sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'customers', @role_name = NULL;
3. Verify SQL Server Agent is running — CDC depends on it for log scanning.
4. Check status:
   SELECT name, is_cdc_enabled FROM sys.databases;