Forum Discussion
Add SQL Server on VM DB (CDC) source to an eventstream
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:
If that VM is in a location where the Fabric service cannot see it directly then you need to use a gateway.
4 Replies
If that VM is in a location where the Fabric service cannot see it directly then you need to use a gateway.
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
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
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
