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

[Jaga212]

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:

[v-prasare]

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

[v-prasare]

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

[v-prasare]

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

[lbendlin · Accepted solution]

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