SSAS 2008: Class not registered REGDB_E_CLASSNOTREG

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

Avatar
Riwut Libinuko
Sr. Cloud Solution Architect

My research interests include distributed robotics, mobile computing and programmable matter.

comments powered by Disqus

Related