Forum Discussion
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" } Artifact ID: 2d602c2e-fabf-41c3-b3e0-fa2a6f7b613e Action: createEventStreamSource Type: SqlServerOnVmDbCdc
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.
7 Replies
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.Hi!
I'm experiencing the same issue (Property 'username's value '' is invalid) when trying to use a connection created under "Manage Connections and Gateways" with an On-premises Data Gateway.
The connection requires the gateway to work, but I can't configure the "Use encrypted connection" option, and I keep getting the same error when using it in Eventstream.
Could you please help me with this?
The 'On-premises Data Gateway' is not supported in Eventstream. Currently, Eventstream supports to get the SQL CDC data from a publicly accessible SQL server. If you have your SQL server in an On-Prem environment with public resovable address, you may try the 'IP allowlist' approach: Connect to Streaming Sources in Virtual Network or On Premises with Eventstream - Microsoft Fabric | Microsoft Learn. If your SQL server doesn't have the public resolvable address, you may join our connector VNET/On-Prem support private preview program. You may contact me through this forum messenger so that I can share you the sign-up form.
You are on the right time. The Eventstream connector vNet injection feature with streaming virtual network data gateway is just released for public preview. You may refer to this public materials for more details: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/streaming-connector-private-network-support-overview
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
'Streaming virtual network data gateway' is the right one for Eventstream connector to bring the real-time data from your private network source. For your case, the SQL CDC on VM.
