Forum Discussion

PWTRyanWhite's avatar
PWTRyanWhite
Frequent Visitor
1 year ago
Solved

SQL Server on VM DB Error

Honestly, I've been searching all over the internet for this error. What does it mean? Failed Failed to create event stream source. Error: { "details": "Property 'username's value '' is invalid" } Ar...
Eventstream
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi PWTRyanWhite ,

    "Property 'username's value '' is invalid"

    This means that the system is expecting a valid value for the username property, but it received an empty string (' ') instead. Essentially, the username field is either missing or not properly configured in the setup.

    Because Fabric event streams currently supports only Basic authentication, you must provide the username and password which have the necessary permissions to access the SQL Server instance and enable CDC.

    For specific connection steps, you can refer to this document:
    Add SQL Server Change Data Capture as a source to eventstream - Microsoft Fabric | Microsoft Learn

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ToddChitt's avatar
ToddChitt
Super User
5 months ago

I can't tell you how disappointed I am that CDC from an on-premise SQL server is NOT supported for a Fabric Event Stream. Let's recap:

* CDC is needed and supported for mirroring an on-premise SQL Server via a gateway

* CDC is used for the new Delta Flow (currently in preview)

 

If you are of the same mind, please consider voting on this Idea: Please allow CDC from On-Premise SQL Server (via g... - Microsoft Fabric Community