SAP Knowledge Base Article - Public

2541606 - SQL Error : "insufficient privilege" when connecting to HANA system in Analysis for Office


The error below is occurring in Analysis for Office when trying to connect to HANA system:

"Caught exception : exception 42111: SQL Error : insufficient privilege: Not authorized at ptime/query/checker/ (42014)"

The HANA revision is lower than 102.06.


SAP BusinessObjects Analysis, edition for Microsoft Office


Refer to SAP note 2339729 for the solution, which is an upgrade in HANA side, or use the workaround mentioned in the note.


privilege, authorization, role, user, logon, login, access, unable, error, exception, authorized , 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