KNOWLEDGE BASE

Error "password authentication failed " Connecting to Redshift


Published: 24 Jan 2014
Last Modified Date: 17 Aug 2015

Issue

When you try to connect to Amazon Redshift from Tableau Desktop, if the database password contains special characters, one of the following errors might occur:
 
An error occurred while communicating with the data source.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

FATAL: password authentication failed for user "<user name>"

FATAL: password authentication failed for user "<user name>"

Unable to connect to the server "<server name>". Check that the server is running and that you have access privileges to the requested database.
 
Or

Invalid username or password

Environment

  • Tableau Desktop
  • Amazon Redshift

Resolution

Remove all special characters from the Redshift password.

Additional Information

This error has been reported with the following characters:
  • +
  • @
  • {
  • }
  • )
  • ;
Customers have also reported being able to connect to Redshift using the same username/password via SQL workbench, which uses JDBC.
Did this article resolve the issue?