SAP Knowledge Base Article - Public

2437428 - Error: "The remote server returned an error: (500) Internal Server Error" when connecting to HANA


The SSO is not working when connecting from Analysis Office to HANA system via OLAP connection defined in BIP/CMC.

The trace contains the following entries when trying to access HANA (http(s)://<server>:<port>/sap/bc/ina/service/v2/GetServerInfo):

The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at iRequest, String purpose)
at iUser, String iPassword, String iTicket)


SAP Analysis for Microsoft Office


The issue may occur because the SAML Service Provider name (in HANA side) is not the same as the Service Provider Name defined in BIP/CMC.


Make sure that the SAML Service Provider name (in HANA side) is exactly the same as the Service Provider Name defined in BIP/CMC. These two fields (shown below) must be the same:

BIP configuration.png

Screenshot showing the configuration in CMC/BIP side

HANA side config.png

Screenshot showing name of Service Provider in HANA side


saml, sso, single, sign, on, single-sign-on, automatic, authentication, logon, prompt, dialog, user, unable, configuration, configuring, hana, db, login, olap connection, xs, serviceprovider , KBA , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions