SAP Knowledge Base Article - Preview

3654917 - analysis office single sign-on (sso) connection failure to hana

Symptom

  • Single Sign-On (SSO) connection from Q system to HANA generates a login panel for the user.
  • Error message displayed: "Analysis Office currently is not able to establish a connection."
  • Error details from logs: "The remote server returned an error: (401) Unauthorized."
  • Works as expected in production environment 
  • Assertion authentication for user  failed with reason: ptime::PtimeException
  • InternalError: dberror(CallableStatement.execute): 129 - transaction rolled back by an internal error: Remote Source is not accessible: Cannot open database requested by the login. The login failed. 


Read more...

Environment

Security & User Management
SAP Analysis for Microsoft Office 2.8 

Product

SAP Analysis for Microsoft Office 2.8

Keywords

analysis office, sso failure, hana connection, unauthorized error, 401 error, edw_qas, edw_prd, sap hana, single sign-on, sap.bc.ina.service.v2.userRole::INA_USER, kerberos settings, saml identity provider, time zone alignment, authentication error , KBA , HAN-DB-SEC , SAP HANA Security & User Management , BI-RA-AO-XLA , Excel Addin , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.