Forum Discussion
Eventstream - SQL Server CDC on VM DB Error
Hi v-sathmakuri . I´ve performed some tests but without success. The DBA is reviewing the permissions you mentioned but as he told me before, they were already ok.
We are connectiong using SQL authentication and I can ingest data from other tables, not CDC, using the same connection without any issues.
Thank you for all your support and I let you know soon about new tests.
Hi ricauduro ,
Thank you for reaching out to Microsoft Fabric Community.
Even when using Basic Authentication, you should verify the connection through the Fabric portal. To do this, navigate to the Manage connections pane, locate the SQL Server connection, and click Edit to confirm or update authentication details.
CDC connections don’t always support Windows Authentication or integrated authentication by default. It’s essential to use SQL Authentication and ensure that the SQL user has access to the target database. The user must also have CDC-related permissions such as SELECT and VIEW DATABASE STATE to facilitate data capture.
Additionally, the SQL user needs the appropriate permissions to access specific CDC system tables and functions. This includes read access to cdc.change_tables, cdc.lsn_time_mapping, and the ability to execute fn_cdc_get_all_changes_* functions, which are crucial for retrieving change data.
There are scenarios where a connection might appear valid in the interface but is not properly registered for CDC. In such cases, try deleting and re-creating the connection directly through the Eventstream source setup. Restarting the Fabric runtime or workspace can help refresh the environment.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!