KNOWLEDGE BASE

Error "Class not registered" Connecting to Microsoft Analysis Services


Published: 30 May 2014
Last Modified Date: 15 Jul 2015

Issue

When you try to connect to Microsoft Analysis Services from the 64-bit version of Tableau Desktop on a computer that is a running a 32-bit version of Microsoft Office 2013, the following error might occur:
 
The drivers necessary to connect to this database are not properly installed.
Database error 0x80040154: Class not registered connecting to Microsoft Analysis Services
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Desktop 8.1 (64-bit) and later versions
  • Microsoft Analysis Services (MSAS)
  • Microsoft Office 2013 (32-bit)

Resolution

Use one of the following workarounds.
  • Uninstall the 32-bit version of Microsoft Office 2013 and install the 64-bit version of Office 2013.
  • Uninstall the 32-bit version of Office 2013 and install Office 2010.
  • Uninstall the 64-bit versions of Tableau Desktop and install the 32-bit version of Tableau Desktop.
Did this article resolve the issue?