Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Cannot create Eventstream from SQL Server (CDC)

Hi,

 

We have an on-premises SQL Server, which is accessible via a data gateway, and CDC (Change Data Capture) is enabled on the server.

 

We are attempting to capture CDC changes from this on-premises SQL Server into our lakehouse.

However, when we try to create an event stream using the 'SQL Server on VM DB (CDC)' as the source through a SQL connection, we receive an error message: 'There was an error in the process. Please try again later.' The error doesn't provide a specific cause and simply asks us to retry.

 

Could you please confirm if it's possible to use an on-premises SQL Server as the source, or is it required to use a SQL Server hosted on an Azure VM instead?

 

 

Attaching the error message screen shot

 

 

Eventstream
  • Wenyang's avatar
    Wenyang
    1 year ago

    Hi Anonymous ,

     

    Thanks for the feedback.

     

    Currently, on-premises SQL Server is not supported. We are actively working on addressing this limitation.

     

    Please feel free to reach out with any further questions.

     

    Best regards,
    Wenyang

2 Replies