KNOWLEDGE BASE

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


Published: 22 Dec 2014
Last Modified Date: 28 Aug 2017

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.

Additional Information

Note: Connecting using a SAPUILandscape.xml file is not currently supported or tested. Ensure that you are using a saplogon,ini file to connect.
Did this article resolve the issue?