Forum Discussion
EventStream - SQL Server on VM DB (CDC)
Hi burakkaragoz
I have created a login on SQL server and tested it in SSMS. Also i have given the db_owner permission to the login , enabled mixed authentication , have enabled CDC for the db and the tables and verified it , the connections and gateway are online , still i am facing this issue
Hmm, that's weird if you've got the SQL login working in SSMS but EventStream is still complaining about an empty username.
A few things to double-check:
In the EventStream connection setup:
- Are you definitely typing the username in the right field? Sometimes there are multiple auth sections
- Try the username without any domain prefix (just sqluser, not domain\sqluser)
- Make sure there are no trailing spaces in the username field
Gateway-related issues: Since you mentioned the gateway is online, this might be a gateway configuration problem:
- Is the gateway service running under an account that can reach your SQL Server?
- Try testing the connection directly on the gateway machine
- Check if there are any firewall rules blocking the gateway from reaching SQL Server
EventStream-specific quirks:
- What's the exact format you're using for the server name? Try both servername\instance and servername,port formats
- Is your SQL Server instance named or default? Named instances can be tricky with EventStream
Debug step: Try creating a simple data flow (not EventStream) to the same SQL Server first. If that works, then it's definitely an EventStream-specific issue.
Can you share the exact server name format you're using and whether it's a named instance? That might help narrow down the issue.
This response was assisted by AI for translation and formatting purposes.