Connector Improvement: SQL Server HVA Windows Auth Feature - Missing Fields for Windows User / Pass?
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.
Please sign in to leave a comment.
Comments
0 comments