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

