You can translate the question and the replies:

Not able to connect to SQL Server using an Active Directory account

Hello, 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.
user
14-09-2018 14:01:12 -0400

2 Answers

Hi, If you want to log into your SQL Server instance using Active Directory, I’d advise you to follow the following article of our knowledge base: [How to configure a VDP database with LDAP authentication](https://community.denodo.com/answers/question/details?questionId=9060g0000000B4WAAU&title=Not+able+to+connect+to+SQL+Server+using+an+Active+Directory+account). There, you can find a complete description of how to configure LDAP authentication for virtual databases in Denodo Virtual DataPort Server. Hope this helps!
Denodo Team
17-09-2018 08:55:00 -0400
Hi, Just as an update. The link I was referring to in the last comment was the following: * [Accessing MS SQL Server using Windows Authentication](https://community.denodo.com/kb/view/document/Accessing%20MS%20SQL%20Server%20using%20Windows%20Authentication?category=Security) There you can find the information referred to in my comment above. Hope this helps!
Denodo Team
14-04-2020 04:35:40 -0400
You must sign in to add an answer. If you do not have an account, you can register here