KNOWLEDGE BASE

Error "DataSourceException: Database error 0x80040E4D: Authorization Failed" Refreshing SAP BW Extract


Published: 22 Dec 2014
Last Modified Date: 18 Nov 2015

Issue

When using a scheduled task to refresh a SAP BW database, the extract might fail with the following error:

com.tableausoftware.nativeapi.dll.DataSourceException: Database error 0x80040E4D: Authorization failed. 

Environment

  • Tableau Server
  • SAP NetWeaver Business Warehouse

Resolution

Verify that all computers running Tableau Server are able to connect to SAP BW:

Option 1

  1. Ensure that Tableau Server is configured to use a Run As User account. For more information, see Run As User.
  2. On the computer that is running Tableau Server, sign in to Windows as the Run As User.
  3. Run SAP Logon and create the SAP BW server connection.

Option 2

Use this option if the Run As User account is set up as a service account and does not have Windows sign-in permissions.
  1. On the computer that is running Tableau Server, sign in to Windows as an administrator.
  2. Create an SAPLOGON_INI_FILE system environment variable and set its value to the file path (file name included) of a valid saplogon.ini file (for example, C:\SAP\saplogon.ini).
  3. Run tabadmin restart to restart Tableau Server. For more information, see tabadmin.

Cause

Tableau Server is unable to connect to SAP BW due to issues with accessing the SAPLogon.ini file.
Did this article resolve the issue?