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
- 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
- Click Create button.
- 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
- Confirm the password of this HANA DB User is valid.
- Create the connection again with the correct one.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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