SSAS 2008: Class not registered REGDB_E_CLASSNOTREG

By | January 10, 2013

English

This morning I was having problem with one of my VM. When I tried to access SSAS (SQL Server Analysis Services) and browse the cube – it throws error :

             Class not registered (Exception from HRESULT:  0x80040154 (REGDB_E_CLASSNOTREG))

SSMS (SQL Server Management Studio) also open error message dialog box:

            Exception of type ‘System.Windows.Forms.AxHost+InavlidActiveXStateException’ was thrown.

Looking deep into detail error message, its clear that this function was called by Microsoft.AlaysisService.Browse.BrowseHostControl.LoadBrowser()

So what is the problem?

The problem is that in fact SSAS 2008 is still using OWC 11. The LoadBrowser() method is trying to call OWC 11 ActiveX, which in my case was uninstalled since I removed all Office 2003 related stuff; thus including Office 2003 Web Components.

Resolution

The resolution is easy, if you still have Office 2003 installer – open your installer and setup OWC 11 from the installer. Otherwise, you just need to download Office 2003 Web Components from Microsoft and install it.

Download

Office 2003  Add-in : Office Web Components : http://www.microsoft.com/en-us/download/details.aspx?id=22276

 

Leave a Reply