In the FiveTran UI, when I switch to Windows Auth (screenshot above), the form asks for server name, but not (Windows AD) User Name or Password.  As such, UI is confusing..

• Minor:  ‘Host’ becomes ‘Server Name’:  Better to stick with one or the other label. Same, right?
• Port: Disappears.  Is that okay?
• No fields to enter the new AD Svc Account’s Username, nor it’s password.
• Still wanting (needing) to connect via SSH-Tunnel, no thing changed there.

…so, (assumably because no AD credential (Username /Pass ) entered) the test failed, as follows: 

“

Unable to connect to database

F_JD21AE: Unable to connect to SQL Server database 'CAMOLTP' on node 'SANCAMSQLD01'. DBMS error [[ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. [ODBC Driver 17 for SQL Server][SQL Server]Cannot open database "CAMOLTP" requested by the login. The login failed]. DBMS error number [18456]. SQL State [28000]. DBMS version [unknown]. Last query [none].

“

Or, maybe we missed a step in the setup instructions?

Just to be sure, I re-tested it with the SQL-Server (user/password) auth (not that we’ll be approved to use it, but just to rule-out the above error cause), and all connection tests passed, as before.