KNOWLEDGE BASE

Errors: "Invalid Username or Password" or "Database error 0x80040E4D: Authorization failed" When Connecting to SAP BW


Published: 27 Dec 2016
Last Modified Date: 14 Apr 2017

Issue

When attempting to connect to SAP BW, the following errors might occur:
 
"Invalid Username or Password"

Or

"Database error 0x80040E4D: Authorization failed"

Environment

  • Tableau Desktop 
  • SAP NetWeaver Business Warehouse

Resolution

Work with your internal Database administrator when investigating this issue and when performing the steps below:
  1. Open SAP Logon
  2. Right-click on the Connection and select Properties.
  3. Access the Network tab and uncheck Activate Secure Network Communication.
Once the steps above are complete the connection should succeed in Tableau Desktop.

Cause

It is possible that some additional configuration should be made on SAP in order to allow SNC when connecting to SAP BW from Tableau Desktop. This should be investigated internally with the Database administrator. 
Did this article resolve the issue?