KNOWLEDGE BASE

Error "Database error 0x80004005 ... Exception has been thrown by the target of an invocation." connecting to Microsoft Analysis Services hosted on Azure


Published: 30 Nov 2018
Last Modified Date: 30 Nov 2018

Issue

When trying to connect to Microsoft Analysis Services hosted on Azure (also known as AAS, Azure Analysis Services), the following error occurs:
 Database error 0x80004005: COM error: COM error: mscorlib; Exception has been thrown by the target of an invocation.. Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

Excel will be able to connect successfully from the same computer.

Environment

  • Tableau Desktop 
  • Microsoft Analysis Services hosted on Azure (also known as Azure Analysis Services Server)

Resolution

Step 1: Verify Client Libraries and install if needed.

  1. From the AAS dashboard, select Settings > Connection Strings.
  2. Hover over the "i" icon to the right of "Provider" and click on the "Analysis Services Data Providers" link.
    .Step 1 Illustration
  3. Follow the steps in Client libraries for connecting to Azure Analysis Services  to install MSOLAP(amd64), MSOLAP(x86), AMO, ADOMD libraries. 
  4. Verify that msolap.dll is version 15.0.2.39 and Microsift.AnalysisServices.DLL and Microsoft.AnalysisServices.AdomdClient.dll are version 15.7.0.2. 

    Step 2 Illustration

Step 2: Set up the connection in Tableau Desktop.

  1. Select Connect > To a Server > More > Microsoft Analysis Services. 
  2. In the connection dialog, do the following:
    • In Server, paste the Azure Analysis Services server name.
    • Select "Use a specific username and password".
    • For Username, enter the email address you use to sign in to the Azure portal.
    • For password, input a single space. A pop up window will appear to authenticate you through Azure Multi-Factor Authentication.

    User-added image

Cause

The MSOLAP drivers are attempting to authenticate immediately with a username/password combination.  Since the Azure proxy requires authentication before you can communicate with the Analysis Services server, the connection attempt is failing.
Did this article resolve the issue?