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

    Question

  • Hi,

    Iam getting

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

    error, when Iam trying to browse a cube in the SQL Management Studio or the Business Intelligence Development Studio. Please let me know how to resolve this asap. Iam able to query on the cubes using mdx, but to see the pivot table view or browse tab, iam getting the above error. Iam using SQL Server 2005 and Visual Studio 2005.

     

    Regards,

    Varma.

    Tuesday, January 24, 2006 12:30 AM

Answers

  • Most likely the OWC component installation became corrupted.

    Try to repair your "Microsoft Office 2003 Web Components" installation.

    Edward.
    --
    This posting is provided "AS IS" with no warranties, and confers no rights.


     

    Wednesday, February 22, 2006 2:10 AM
    Owner

All replies

  • I am getting the same error.  I am seeing a lot of people reporting this error, on other forums, but no one has an answer. 

     

    Saturday, February 18, 2006 6:43 PM
  • Try www.sysinternals.com filemon & regmon tools to determine which assembly is missing.  Regmon should tell you what key it is trying to find in the registry.

    Perhaps try repairing MDAC?

    http://www.macropool.com/en/download/repair_mdac.html

    Check to make sure Pivot Table service is installed.  PTSFull.exe

     

    Tuesday, February 21, 2006 2:43 PM
  • Most likely the OWC component installation became corrupted.

    Try to repair your "Microsoft Office 2003 Web Components" installation.

    Edward.
    --
    This posting is provided "AS IS" with no warranties, and confers no rights.


     

    Wednesday, February 22, 2006 2:10 AM
    Owner
  • WORKED FOR ME!!!

    http://www.microsoft.com/downloads/details.aspx?FamilyID=7287252c-402e-4f72-97a5-e0fd290d4b76&DisplayLang=en


    Wednesday, February 22, 2006 4:13 PM
  • Thanks Edward.
    Wednesday, May 03, 2006 7:11 AM
  • I had this problem and reinstalling OWC fixed it for me.

     

    Friday, December 01, 2006 10:46 AM
  • This worked perfectly in about 1 minute. THANK YOU!
    Tuesday, January 09, 2007 5:40 PM
  • Hi! 

     I installed the OWC from http://www.microsoft.com/downloads/details.aspx?FamilyID=7287252c-402e-4f72-97a5-e0fd290d4b76&DisplayLang=en.

    It worked for me. Thanks a lot to all esp. BlackadderX and Edward Melomed

     

    Tuesday, February 20, 2007 4:19 PM
  • :o)

    I have to install the OWC 11 and it worked.

    If you have time, you will read this http://blogs.msdn.com/excel/archive/2006/07/17/668544.aspx

     

    Tuesday, February 27, 2007 7:46 PM