by Igor » Sat, 15 Jul 2006 19:13:36
hank you Akshai - I was missing MSXML6.
To be more precise I've installed MSXML6_SDK from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=993c0bcf-3bcf-4009-be21-27e85e1857b1&DisplayLang=enthinking that SDK includes XML parser or whatever it is I need.Only when I installed :msxml6.msi (1.5 MB)from the same page it worked. Differences in those files are not explainedon the page or I missed it.Thanks again,IgorBTW, for those struggling with similar issues I found this link useful too:http://www.dbtalk.net/microsoft-public-sqlserver-olap/cannot-connect-msas-2000-server-177366.html"Akshai Mirchandani [MS]" < XXXX@XXXXX.COM > wrote in messagenews: XXXX@XXXXX.COM ...> It looks like the IXMLA component is not working -- probably it is notinstalled or not available because of a dependency...>> Try to re-register the component -- go to the folder C:\ProgramFiles\Microsoft.NET\ADOMD.NET\90> and do:> regsvr32 msadomdx.dll> This should re-register the COM objects in this DLL -- and if this fails,hopefully it will indicate what may be the problem (e.g. MSXML6 notinstalled?).>> HTH,> Akshai> --> Try out the MSDN Forums for Analysis Services at:> http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1>> This posting is provided "AS IS" with no warranties, and confers no rights> Please do not send email directly to this alias. This alias is fornewsgroup> purposes only.>> "Igor" < XXXX@XXXXX.COM > wrote in messagenews:e95rns$l1e$ XXXX@XXXXX.COM ...>> Hi all,>>>> I have a web app written in asp.net c# that connects to AS2000.>> When I run it on the client connection string:>> connectionString1="provider=msolap;Data Source=server1;initialcatalog=foodmart 2000;">>>> works fine. (note: server1 is NOT locahost but Win.Server 2000 machinerunning AS2000 SP3).>>>> When I deploy the app to the production server with corrected conn string(I have a basic authentication on the virtual dir):>>>> connectionString2="provider=msolap;Data Source=prodServer;initialcatalog=foodmart 2000;">>>> I get:>> ---------------------------------------------------------------->> ERROR TYPE 1:>> [SocketException (0x274d): No connection could be made because the targetmachine actively refused it]>> System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot,SocketAddress socketAddress) +1002002>> System.Net.Sockets.Socket.Connect(EndPoint remoteEP) +84>> System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP) +145>> System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 port)+200>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClientByAddress(String hostName, Int32 port) +295>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +139>>>> [AdomdConnectionException: A connection cannot be made. Ensure that theserver is running.]>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +376>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) +49>>Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfoconnectionInfo, Boolean beginSession) +497>>>>Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServi
