Forum Discussion

Karthikpv's avatar
Karthikpv
New Member
1 year ago

EventStream - SQL Server on VM DB (CDC)

I am facing this issue while trying to connect to a SQL server on EventStream, Error: Property 'username's value '' is invalid. What's the solution?
Real-Time hub
burakkaragoz's avatar
burakkaragoz
Super User
1 year ago

Hi Karthikpv ,

 

Ah, this is a classic "empty field" error. You're probably leaving the username box blank when setting up the EventStream connection.

What's likely happening: EventStream is expecting SQL Server authentication (username/password), but you've left the username field empty. It won't accept Windows authentication for CDC connections.

Quick fix:

  • Create a proper SQL login on your SQL Server instance
  • Use that login's username (not a Windows domain account)
  • Make sure the login has db_owner permissions on the database

CDC-specific gotchas: Your SQL user needs special permissions because CDC is picky. The account needs to read change data, and that requires elevated permissions. Also, make sure:

  • CDC is actually enabled on your database AND the specific tables
  • SQL Server Agent is running (CDC breaks without it)
  • Your SQL Server allows mixed authentication mode

If you're still stuck: Try connecting with SQL Server Management Studio first using the same credentials. If that works but EventStream doesn't, it's probably a permissions issue rather than a connection problem.

What type of authentication were you trying to use? And have you verified CDC is properly set up on the SQL Server side?

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.

  • Karthikpv's avatar
    Karthikpv
    New Member
    1 year ago

    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

    • burakkaragoz's avatar
      burakkaragoz
      Super User
      1 year ago

      Karthikpv ,

      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.