Analysis Services Migration Wizard

I backedup an SQL2K OLAP database. Learned that I can not use the cab file to restore it to an SQL2005. So I've restored it to another SQL2K. Now I am trying to migrate this to my 2005. Here are my tests and results.

1. Welcome screen works fine. :)

2. I have severel SQL2K servers here which have their OLAP services running.

a.) SQL 2000 Source Server: xxxxxxxxx (no such server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .

b.) SQL 2000 Source Server: SABRI (right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .

c.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: ActiveX component can't create object

d.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: xxxxxxxxx (no such server)
Error: Source server: ActiveX component can't create object

e.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: (local) (got bored of typing AATIK)
Error: Source server: ActiveX component can't create object

I've also tried "localhost", ".", "aatik", "aatik\aatik" etc. for destination server.

Is it a bug in Turkish for letters I and i ?

By the way SP1 is installed.

Thanks.

You can take destination out of the picture by specifying script file as a destination.

Looks like you are having problem connecting to AS2000 source server.

Take a look if you can access AS2000 sever remotely. Can you access it from Analysis Manager running on another machine?

You also have an option of running AS2000 and AS2005 on the same machine.
You can rename your AS2005 sever to become a named instance. Install AS2000 locally, restore your databases and then migrate a databases.
Uninstall AS2000 and then rename back AS2005 to be a default instance.

To rename AS2005 instance you can use ASInstanceRename.exe located in your C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE folder.

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

|||

Thanks Edward.

Tried the scriptfile option but again got the same ActiveX error message.