2008 R2 Upgrade Advisor Error - ActiveX Component can't create Object

• Steve-443559

  SSCrazy

  Points: 2309

  More actions

  April 18, 2011 at 8:13 pm

  #235014

  I'm preparing to upgrade a SQL 2008 Enterprise Analysis Cluster to SQL 2008 R2 Enterprise. When I run upgrade advisor, i'm getting the error - ActiveX Component can't create object. Any ideas how to resolve this?

  Thanks,

  S

• Duran

  SSChampion

  Points: 13259

  More actions

  April 19, 2011 at 4:41 am

  #1313248

  Is this helpful? Might solve your issue.

  http://blogs.msdn.com/b/brismith/archive/2007/03/09/activex-component-can-t-create-object-cube-build-failure-against-sql-server-2005-analysis-services.aspx

  Regards,

  D.

• Syed Jahanzaib Bin hassan

  SSChampion

  Points: 11410

  More actions

  April 19, 2011 at 5:48 am

  #1313267

  Data Access Objects (DAO) is not properly registered.

  -or-

  One or more references are missing.

  -or-

  There is a utility database reference that is not valid.

  -or-

  You do not have the required permissions for required libraries.

  -or-

  There is a damaged wizard file.

  check this microsoft link

  http://support.microsoft.com/kb/319844

  Regards,

  Syed Jahanzaib Bin Hassan

  MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

  My Blog

  http://www.aureus-salah.com

  Regards,
  Syed Jahanzaib Bin Hassan
  BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

  My Blog
  www.aureus-salah.com