Re: Problems with Analysis Services Migration Wizard (SQL Server 2005)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Try and repair you "SQL Server 2005 Backward Compatibility" component
installation.

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


"Santiago Sanz" <SantiagoSanz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9186EA92-DEDB-46E8-8136-68E459FA4410@xxxxxxxxxxxxxxxx
Hi!

I have a problem with the Analysis Services Migration Wizard (SQL Server
2005).

When migrating from Analysis Services 2000, I get the following error when
validating the source databases:

Unable to cast COM object of type 'System.__ComObject' to interface type
'Interop.Dso.IPartition90Ex'. This operation failed because the
QueryInterface call on the COM component for the interface with IID
'{F82195C2-53A0-41B5-B7D8-7D087BAE32CF}' failed

due to the following error: No such interface supported (Exception from
HRESULT: 0x80004002 (E_NOINTERFACE)).

I found in another newsgroup this:

"Then I noticed that my DSO dll's are all version 8.0.2039... But the RTC
dlls are 8.05.1054 (which I think are later). So I have no idea why my
DLL's
are so old having just having installed SS 2005. So I copied the DSO
folder
from the RTC virtual PC and made a subfolder to C:\Program Files\Common
Files\Microsoft\DSO\Test. I put the DLL's in here and registered all of
them.
restarted AS 2000, and The Migration Wizard now works".

I don't know how means "RTC" and I don't know where I can find this
libraries. Can you help me?

Thanks!!!

Santi


.



Relevant Pages

  • RE: SQL Server Management Studio error on connection
    ... Unable to cast COM object of type 'System.__ComObject' to interface ... Which edition of SQL Server are you using? ... Do you have Visual Studio installed on the machine as well? ... installation, ...
    (microsoft.public.sqlserver.tools)
  • Re: HELP - Ideas for Oracle / MS Sql Interface.
    ... I've been asked to look at developing a new interface between Oracle ... Oracle 9i installation on Solaris 9. ... Sql Server DB running on Windows and accessed via a VPN. ...
    (comp.databases.oracle.server)
  • Re: Can MSDE 2000 be installed with Sql Server 6.5
    ... > Will the installation of MSDE cause issues for SQL Server 6.5? ...
    (microsoft.public.sqlserver.msde)
  • [NT] SQL Server Installation Process May Leave Passwords on System
    ... service pack for SQL Server 7.0 or SQL Server 2000, ... without having to actually perform an installation. ... to SQL Server 7.0 Service Pack 4, the passwords were stored in clear text. ... information in the setup.iss and log files would not allow any access. ...
    (Securiteam)
  • Maybe this could help
    ... I've found a solution to update SQL Server to SP3. ... It also works with SP2. ... Product Installation Status ... No mapping between account names and security IDs was done. ...
    (microsoft.public.sqlserver.setup)