You can translate the question and the replies:

Denodo ODBC Driver - Incorrect Username/Password

Hi - very new to this so sorry if anything is missing! Installed Denodo 7 ODBC driver and setup under system DSN with my computer sign on information (I am an admin). I have this installed to run Power BI refreshes, everything was great for about a month or two but noticed that that the Power BI refreshes started failing on the reports connected to Denodo. When running the ODBC driver connection test on my computer it will say connection successful most of the time and then will randomly fail with the following: Authentication ERROR: The username or password is incorrect DETAIL: java.sql.SQLException: authentication error: The username or password is incorrect. No passwords or usernames have been changed. Any ideas as to why this error is occurring? Thank you!
user
26-06-2023 11:55:32 -0400
code

1 Answer

Hi, This configuration is very common and should work. 1. Make sure you have the ODBC driver update that match the your current VDP update, you can download the driver from [here](https://community.denodo.com/drivers/odbc/7.0). 2. Double check the DSN configuration, especially Datasource page for Windows, or *denodoDSN.template* parameters for Linux: [Set Up a DSN on Windows](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_odbc/configuration_of_the_odbc_driver_on_windows/configuration_of_the_odbc_driver_on_windows#set-up-a-dsn-on-windows) or [Set Up a DSN on Linux and Other UNIX](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_odbc/configuration_of_the_odbc_driver_in_linux_and_other_unix/configuration_of_the_odbc_driver_in_linux_and_other_unix#configuration-of-the-odbc-driver-in-linux-and-other-unix). In addition, if you are using Windows Authentication with Kerberos, double check the configuration under *Advanced options* as shown here [Windows authentication](https://community.denodo.com/docs/html/document/denodoconnects/7.0/en/Denodo%20Power%20BI%20Custom%20Connector%20-%20User%20Manual). 3. If the error is still present, open VQL Shell in Design Studio o VDP Administration Tool and temporary increase log level: `CALL LOGCONTROLLER('com.denodo.vdp.requests', 'INFO')` By default all requests are logged in `<DENODO_HOME>/logs/vdp/vdp-requests.log`. Try executing the connectivity test again or use the same user to login in **VDP Administration Tool**. When you obtain the error check the *vdp-requests.log* file. Hope this helps
Denodo Team
27-06-2023 09:53:18 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here