When trying to add a ODBC connection as an event source, I receive login failure events on the SQL server.
Error: 18456, Severity: 14, State: 6
State: 6 = Attempt to use a Windows login name with SQL Authentication
The account I'm using is a windows account, however the Netwintess ODBC connector appears to default to SQL authentication over Windows authentication. Is there a way to force Windows authentication for ODBC connections?
Add in the DSN definition the following attributes:
AuthenticationMethod=9
Domain=YourDomain
The driver will append to the username the Domain (tested with version DataDirect ODBC v7.1).