KNOWLEDGE BASE

Error "Sign in failed... Check credentials for typos and confirm that you can access the database directly" Refreshing Salesforce Extract


Published: 06 Apr 2016
Last Modified Date: 22 Jan 2020

Issue

When refreshing a Salesforce extract that has embedded Salesforce username and password, the refresh might fail and the following error might occur:

Sign in failed... Check credentials for typos and confirm that you can access the database directly

In the Edit Connection dialogue, the authentication type is set to "Embedded Salesforce username and password in the connection" and Test Connection is successful.

Additionally, the following error might appear in the Tableau Server Admin view:

INVALID_LOGIN: Invalid username, password, security token; or user locked out.

 

Environment

  • Tableau Server 
  • Salesforce

Resolution

Option 1

Embed credentials using the OAuth option:
  1. Open Edit Connection.
  2. Select "Embedded Salesforce credentials in the connection".
Note: This will require configuring Tableau Server and Salesforce for Oauth connections. For more information, see Set Up OAuth for Salesforce.

Option 2

Download the data source or workbook, open in a recent version of Tableau Desktop and republish.
Did this article resolve the issue?