KNOWLEDGE BASE

Error "Access denied for user .... Invalid username or password" Using Correct Password with ODBC Connection


Published: 27 Jun 2016
Last Modified Date: 25 Sep 2017

Issue

When you try to connect to a data source using ODBC and the correct credentials, the following error occurs:
 
"[database][ODBC Driver]Access denied for user 'username'@'IP' (using password: YES) Invalid username or password."

Environment

  • Tableau Desktop
  • ODBC 

Resolution

Change the database password so it does not include any of the following special characters:
[] {}() , ; ? * ! @.

Cause

ODBC does not support the characters [] {}() , ; ? * ! @. in passwords.
 
Did this article resolve the issue?