September 28, 2006 at 12:37 am
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
September 28, 2006 at 7:51 am
As I understand it, (the) SQL Browser (Service) is installed with a default of 'off' if the install is a new one (this is a surface area reduction initiative). If you've upgraded your server, then it's on. Check your services control panel and see if it's running, if it's not, try starting that service and then try connecting to the Analysis Services server. You can (supposedly) connect to the server even without having the browser running but you need to specify the port that you're trying to access the AS service on (port 2383 unless you specified a different one at install). It might help to check that the AS service is itself running too.
Cheers,
Steve.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply