Errors: "Invalid Username or Password" or "Database error 0x80040E4D: Authorization failed" When Connecting to SAP BW
Published: 27 Dec 2016 Last Modified Date: 12 Jan 2018
When attempting to connect to SAP BW, the following errors might occur:
"Invalid Username or Password"
"Database error 0x80040E4D: Authorization failed"
SAP NetWeaver Business Warehouse
Work with your internal Database administrator when investigating this issue and when performing the steps below:
Open SAP Logon
Right-click on the Connection and select Properties.
Access the Network tab and uncheck Activate Secure Network Communication.
Once the steps above are complete the connection should succeed in Tableau Desktop.
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.
Thank you for providing your feedback on the effectiveness of the article.