Monday, March 26, 2012

Migrating AS2000 to AS2005 on two seperate machines

Hi champs!

I have two seperates machines, one SQL2000 with some Cubes, and one with sql2005 and AS 2005.

I've tried the migrate wizard, but the sql2005 machines cannot connect to the sql2000 machine through OLAP connection.

The two machines ar in the same workgroup, but not in a domain.

Do I have to make a linked server connection? and if so how exactly is the syntax for connecting to a 2000 OLAP cubes?

I've tried to install AS2000 on my sql2005 machine, but that will not work.

I cannot restore AS2000 cubes on the AS2005 either.

/Many thanks

For one, to be able to install AS2000 on AS2005 machine you need to make sure you are running Analysis Server as named instance.

You can ether reinstall AS2005 and choose it to be named instance or use ASInstanceRename utility to rename defult instance. After that you should be able to install AS2000.

As for not being able to migrate from remote machine, if you choose to go that way. Try first installing AS2000 tools- Analysis Manager and use and work out through process of being able to use that to remotely access AS2000 server. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

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

No comments:

Post a Comment