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

Hi,

I have successfully created a project (using VS.Net 2003 and SQL Server Analysis Services 2000) which is dynamically retrieving dimensions, levels, and members, and i generating and executing a query as per user needs and requirements. However when I tried to deploy the project on another machine, even though the apps is running fine, and the query getting generated, when its trying to show the data in the report-display page using ADOMD.Net, the following error was shown.

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SocketException (0x274d): No connection could be made because the target machine actively refused it]

System.Net.Sockets.Socket.Connect(EndPoint remoteEP) +307

System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP) +24

System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 port) +81

Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +208

[AdomdConnectionException: A connection cannot be made. Ensure that the server is running.]

Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +384

Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) +51

Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) +398

Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection+IXmlaClientProviderEx.ConnectXmla() +124

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) +144

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() +601

cubicdimension.Reportdisp.Page_Load(Object sender, EventArgs e) in E:\Inetpub\wwwroot\cubicdimension\Reportdisp.aspx.vb:65

System.Web.UI.Control.OnLoad(EventArgs e) +67

System.Web.UI.Control.LoadRecursive() +35

System.Web.UI.Page.ProcessRequestMain() +731

May I mention here, that the computer where I tried deploying, has SQL Server 2000 as well as SQL Server 2005. I tried reinstalling MSXML, but the computer already has a higher version of MSXML.

Any help in this regard would be appreciated.

Best Wishes.

Check Programs/SQL Server 2005/ Configuration tools/SQL Server Surface Area Configuration.

In "Surface Area Configuration for services and connection", you click on the service and remote connections.

See that you have local and remote connections activated.

HTH

Thomas Ivarsson