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
On Apr 9, 11:17 am, "Cindy Lee" <cindy...@hotmail.comwrote:
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.AdomdConnec tionException: 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(Str*i
ng hostName, Int32 port) at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. GetTcpClient(ConnectionIn*f
o connectionInfo) --- End of inner exception stack trace --- at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. GetTcpClient(ConnectionIn*f
o connectionInfo) at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. OpenTcpConnection(Connect*i
onInfo connectionInfo) at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. Connect(ConnectionInfo
connectionInfo, Boolean beginSession) at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.XmlaClientProvider..M*i
crosoft.AnalysisServices.AdomdClient.AdomdConnecti on.IXmlaClientProviderEx.*C
onnectXmla() at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ConnectToXMLA(Boolea*n
createSession, Boolean isHTTP) at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.Open() at
MdxToXML.GetBasicInfo(String zone_id, String partner_id, String ct_id)