Migrating OLAP Cubes from Analysis Services version 8.00 from SQL Server 2000 to SQL Server 2005

Hi,

I am trying to migrate OLAP Cubes from Analsysis Services in SQL Server 2000 version 8.00 to SQL Server 2005. I installed SQL Server 2005 as a named instance "SQL2005" . I then invoked the MigrationWizard.exe , where i gave the following

Source Server - <My Server Name>

Destination Server - <My Server Name>\SQL2005

When i click Next i get the error when it tries to connect to destination server.The error msg is

"Destination server: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running"

When i give the Destination Server as <My Server Name> i get the following error msg

"Destination server: A connection cannot be made. Ensure that the server is running"

When i try to connect to Analysis Services from SQL Server Management Studio i get the following error

TITLE: Connect to Server

Cannot connect to MISOM131.


ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

No connection could be made because the target machine actively refused it (System)


BUTTONS:

OK

Kindly let me know what i should do . I have installed Analysis Services on SQL 2005 during the installation . I am not sure abt the problem. Any help will be really appreciated

Satya

[1501 byte] By [satyan] at [2007-12-24]

SQL Server

Site Classified