Forum Discussion
SQL Server on VM DB Error
- Anonymous1 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.
'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.