SAP Knowledge Base Article - Public

2966336 - Connection to database fails

Symptom

  • Creating an Import Data Connection to S/4HANA fails
    • On Screen Error: "The user doesn't have permission to access the requested resource."

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Log into SAC tenant with user.
  2. Navigate to menu (top left corner) click Connections.
  3. Click the + (add) button. 
  4. Choose SAP S/4HANA under Acquire Data.
  5. Fill in relevant information.
  6. Click "Create" observe error.

Cause

  • This behavior has been observed if "Host In Request Header" setting in "Cloud to On-Premise">"Mapping Virtual To Internal System" is set to "Virtual Host"

Resolution

 Check configuration in SAP Cloud Connector.

  1. Log into Cloud Connector with Administrator account.
  2. Click "Cloud to On-Premise" (navigation on the left.)
  3. Click the edit (pencil icon under Actions) on the Mapping Virtual To Internal System that is pointing to the Cloud Agent.
  4. Validate "Host In Request Header" is set to "Use Internal Host"
  5. Save.

See Also

Keywords

S/4HANA, HANA, Connection, Import, SAC, Cloud, On Prem, On Premise, EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, model, SBOC, SAC, BW , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions