SAP Knowledge Base Article - Public

3275385 - "You are not authorized to query the remote system. Please ask your administrator to grant you the InA role" error occurs when creating a Live Connection to SAP HANA

Symptom

  • The following error message occurs when creating a Live Data Connection to SAP HANA On-Premise Using a Direct Connection in SAP Analytics Cloud (SAC): "You are not authorized to query the remote system. Please ask your administrator to grant you the InA role".
  • The sap.bc.ina.service.v2.userRole::INA_USER role has been assigned to the user who use the connection. 
  • When accessing URL https://<xs-host:port>/sap/bc/ina/service/v2/GetServerInfo with the HANA DB user, see error:" Password change required to complete authentication. Please change your password here."

Environment

  • SAP Analytics Cloud
  • HANA2.0 SP06

Reproducing the Issue

  1. Configure a Live Data Connection to SAP HANA On-Premise Using a Direct Connection by following help guide: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/58c890e1c89d41e69b2cec31bac2d95f.html
  2. Click Create button.
  3. Get error "You are not authorized to query the remote system. Please ask your administrator to grant you the InA role".

Cause

 The password of this HANA DB User has been expired.

Resolution

  1. Confirm the password of this HANA DB User is valid.
  2. Create the connection again with the correct one.

See Also

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, HANA, HANA DB, HANA On-premise, HANA2.0, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Live Data Connection, Direct Connection, LDC. , KBA , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem

Product

SAP Analytics Cloud 1.0