topic Re: Add SQL Server on VM DB (CDC) source to an eventstream in Eventstream

Add SQL Server on VM DB (CDC) source to an eventstream

Jaga212 — Tue, 11 Mar 2025 10:33:37 GMT

We have a SQL Server running on a VM.

We’ve created an Event Stream and are attempting to connect it to the SQL Server (CDC) database on the VM. However, we're encountering the following issue.

Has anyone faced a similar problem or have any suggestions on how to resolve it? We’ve already tried allowing all IPs and have reviewed all firewall settings.

We’ve also run the prerequisites outlined in the documentation (EXEC sys.sp_cdc_enable_db;), but we’re still receiving the following errors:

Re: Add SQL Server on VM DB (CDC) source to an eventstream

lbendlin — Tue, 11 Mar 2025 19:32:34 GMT

If that VM is in a location where the Fabric service cannot see it directly then you need to use a gateway.

Re: Add SQL Server on VM DB (CDC) source to an eventstream

v-prasare — Tue, 15 Apr 2025 08:47:17 GMT

Hi Jaga212, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

lbendlin , Thanks for your promt response

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: Add SQL Server on VM DB (CDC) source to an eventstream

v-prasare — Tue, 22 Apr 2025 07:09:31 GMT

Hi Jaga212,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: Add SQL Server on VM DB (CDC) source to an eventstream

v-prasare — Fri, 09 May 2025 03:17:57 GMT

Hi @Jaga212,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query