Advisor Scan Fails

Hey all. I'm in the process of starting an upgrade from SQL2000 to SQL2005. I ran the Upgrade Advisor like suggested and I keep receiving an error.

'Cannot use DSO (Decision Support Objects) to connect to Analysis Services, DSO is either not installed ot the installation is corrupted. Error details: Retrieving the COM class factory for component with CLSID {B492C386-0195-11D2-89BA-00C04FB9898D} failed due to the following error: 80040154.'

Any suggestions or ideas?

Chris

Upgrade Advisor requires DSO. Here is the except from the help files that tells you how to install it.

SQL Server 2000 decision support objects (DSO) are required to scan upgrade issues in Analysis services. To install DSO, insert the SQL Server 2000 media into the CD/DVD drive. This starts the SQL Server 2000 Setup program. Click Install SQL Server 2000 Components. Click Analysis Services to start the Analysis Services Setup program. In Select Components, make sure that the Decision Support Objects component is selected.

Thanks

Michelle