OLAP Connection for Microsoft Analysis Services 2012 Error 401

[Former Member]

We are currently using SAP BusinessObjects BI Platform 4.1 SP5.

When attempting to create an OLAP connection for Microsoft Analysis Services 2012 in the Information Design Tool (IDT) with our server "http://<server_name>/olap/msmdpump.dll" we obtain the following error:

com.businessobjects.mds.olap.protocol.xmla.internal.XMLAException: ErrorCode: 401

Description: Unauthorized.

We are able to view the contents of the databases through SQL Management Studio without any issue and using the same credentials.

Through some other sources we came across, the IIS site that we are using for HTTP access must be configured to allow anonymous access if it is to be used for SAP BI. After enabling the anonymous access we no longer get the error and testing the connection returns successful within the IDT but the database contents that are attached to the IIS site are no longer visible in the IDT or in SQL Management Studio so we cannot interact with any of the objects. We believe this to be due to enabling anonymous access, which prevents authentication of the user and as a result we no longer have the rights to access the databases associated with the server.

Does anyone have any way to work around this issue?

Thank you.

[Former Member]

Have you sorted out this issue? We are having exact the same.

[Former Member]

We got it to work by changing IIS site to use Basic Authentication instead of Windows or Anonymous. We also don't have SSO end-to-end working at the moment so we are currently manually entering credentials to create the OLAP connection.