Skip to Content
Author's profile photo Venkata Subhash Medisetty

How to Resolve Remote server returned an error:(403) Forbidden while connecting to HANA HTTP using Analysis Office 2.x

Hi All,

I do see question frequently coming in community that connecting to HANA HTTP using Analysis Office 2.x, you get an error “Remote server returned an error:(403) Forbidden“.

403.PNG

Follow below Steps  to resolve this issue

You need to Import Delivery Unit “AHCO_INA_SERVICE.tgz” from  Server

/wp-content/uploads/2015/09/inaservice_795267.png

Add the “INA_USER” role to the user Under “Granted Roles” section

grantedrol.PNG

Add the Object Privileges “_SYS_BI” , “_SYS_BIC” & “_SYS_RT” to the user, and  enable checkbox “SELECT” option for those objects

objectprivi.PNG

These steps will helps you to resolve from err “403”

Related :

How to create HANA Http in BIP and consume in Analysis Office 2.0

How to create HANA Http connection in local and consume in Analysis Office 2.0

Step by step how to create a local SAP HANA connection with Analysis for Office 2.x

Thanks & Regards,

Subhash

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thank you very much 🙂

      Author's profile photo Former Member
      Former Member

      Thanks a lot 😀

      Author's profile photo Former Member
      Former Member

      It's very helpful. Thanks for sharing :).

       

      Author's profile photo Tejas Gandhi
      Tejas Gandhi

      Hi Venkata ,

      Thank you for all the information .

      I am trying to use Analysis for Microsoft excel but getting (403): forbidden error . I have done all the things mentioned above.

      I am trying to use it on XSA . Kindly let me know if there are any prerequisite other than EMP-MDS.