AdomdConnectionException

  • Thread starter Thread starter Cindy Lee
  • Start date Start date
C

Cindy Lee

I get the error "No connection could be made because the target machine
actively refused it " when trying to connect with AdomdConnection (the
same code works on other servers). I'm just trying to connect on the local
host.


I'm running windows server 2003 service pack 1. I think I might need to
download something on this server to make ADO work. I can connect with my
perl code which uses soap to call the the cubes. I'm using .NET 2.0 for my
C# code.


Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: A
connection cannot be made. Ensure that the server is running. --->
System.Net.Sockets.SocketException: No connection could be made because the
target machine actively refused it at
System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port) at
Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClientByAddress(Stri
ng hostName, Int32 port) at
Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInf
o connectionInfo) --- End of inner exception stack trace --- at
Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInf
o connectionInfo) at
Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(Connecti
onInfo connectionInfo) at
Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo
connectionInfo, Boolean beginSession) at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Mi
crosoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.C
onnectXmla() at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean
createSession, Boolean isHTTP) at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() at
MdxToXML.GetBasicInfo(String zone_id, String partner_id, String ct_id)
 
do you have the local firewall on?
are you using the machine name or 127.0.0.1?

what version of the client side tools do you have? I assume you're
talking about SQL Server 2000 here :)

SP1 client tools against a SP3/SP4 machine will have problems for sure

-Todos
 
Back
Top