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.
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.
Office 2003 Add-in : Office Web Components : http://www.microsoft.com/en-us/download/details.aspx?id=22276