none
A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

    General discussion

  • I have SQL 2008 Management Studio, and am trying to connet SQL 2005 Analysis Server ..am getting the error like below.Any help is appreciated.

    error message  : No connection could be made because the target machine actively refused it 127.0.0.1:2382 (System)

    location :    at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

    regards

    My SQL Browser is running fine..

    born sql

    ------detail error

       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo)
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
       at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
       at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
       at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
       at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
       at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
       at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

     

    ---------

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to BLRAC8035\STD.

    ------------------------------
    ADDITIONAL INFORMATION:

    A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

    ------------------------------

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

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    • Edited by Born SQL Server Wednesday, November 10, 2010 1:44 PM error details
    Wednesday, November 10, 2010 1:42 PM

All replies

  • Under what account is the SQL Browser service running? If it is a local user (local admin / local system) try changing it to use a domain user account and test again.

    Also, do you see anything in the Server's Windows Event logs when you try to connect? (Application, Security, System)

    I don't have a Server 2008 system unfortunately so I can't test. However, as there seems to be a lot of issues around the SQL Browser service on OS2008 maybe someone from MS can test this and post back the definitive guide...


    http://bi-logger.blogspot.com/
    Wednesday, November 10, 2010 2:21 PM