Monday, March 26, 2012

how did you upgrade from analysis services 2000 to 2005?

i have followed the instructions online ,on how to upgrade from analysis server 2000 to 2005. i install a new instance of analysis services 2005, called instance 1, migrate all the cubes over, but when it comes to using the rename instance tool, i get errors. there is a reg key missing i have found that stops this tool from working. how have you guys gotten around the migration from 2000 to 2005?

What machine are you is it 64bit platform?

There are 2 versions of ASInstanceRename utilities. You should use one that is installed along with 64bit version of Analysis Services in the C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE folder.

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

|||

thats the version of the instanceRename tool but when i try to rename an instance i get this error:


Cannot open regestry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\Sql Bin under HKEY_LOCAL_MACHINE

Thats the only version of the tool i have on my server. I installed sql server 2005 enterprise edition, not the 64bit version though as the server im using is an old server ( used for testing) and is only a 32 bit server.

No comments:

Post a Comment