I am using Denodo 6.0
In the VDP tool, I am trying to connect to a SQL Server database using a Active Directory account (domain \ account name). However, when I test the connection, the tool is telling me: 'Unable to establish Connection. Login failed for user <account name>"
In the user name section, I tried to use the domain with the account name and also just the account name by itself, but I am getting the error either way. Does Denodo require that for SQL Server, the account name used must be a local database account? How can I use the Domain \ Account name in the connection.
The database adapter is Microsoft SQL Server 2008R2 (JTDS). Let me know if I need to change anything to fix the issue.