Feb 01
Class not registered (exception from hresult:0x80040154 (REGDB_E_CLASSNOTREG))

When using SQL Server Management Studio to browse objects in Analysis Services I receive the error class not registered (exception from hresult:0x80040154 (REGDB_E_CLASSNOTREG)).

There are a number of options to consider that will fix this, however the best approach thus far for me was to install the Office 2003 Add-in: Office Web Components - http://www.microsoft.com/download/en/details.aspx?DisplayLang=en&id=22276

This seems counterintuitive since most of us are using SSMS 2008R2, however this does fix the issue with no noticeable issues.

This appears to be a known bug in Microsoft SSMS 2008 and 2008R2 and Microsoft has suggested installing a SSMS 2005 and 2008 side-by-side installation.

ADDITONAL INFORMATION
Browsing a cube, etc. http://msdn.microsoft.com/en-us/library/ms170646(v=sql.90).aspx

Comments

Thank You

OWC Add-in worked for me. Thanks for sharing
 on 11/4/2012 1:58 AM

 ‭(Hidden)‬ Blog Tools