Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal Installation
 xmla error on 64 bit OS		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

keith

New Zealand
26 Posts
Posted - 05/05/2009 :  22:34:44  Show Profile  Reply with Quote
I am experiencing problems trying to get the XMLA virtual directory working properly.

I am installing on a Web Server talking to another server which hosts Analysis Services.

The OS on both machines is Windows Server 2003 x64 with SP2 installed.

The SQL Server / AS version is 2005 with SP2 (3042) 64 bit

When I try setting up a UDL connection it correctly offers the valid choice of AS databases but when I test the connection I get the following error…

Test connection failed because of an error in setting the window handle property. 0x80040e21

When I select “Yes” to continue with the test connection I get the following response…

Test connection succeeded but some settings were not accepted by the provider

TIA

marco

Netherlands
588 Posts
Posted - 05/06/2009 :  23:01:04  Show Profile  Reply with Quote
Hi,

What is the connection string you have added in ReportPortal > Admin ?

Marco
Go to Top of Page

keith

New Zealand
26 Posts
Posted - 05/07/2009 :  12:10:15  Show Profile  Reply with Quote
Hi Marco

xmla/msmdpump.dll

When I try Test I get the following response...

Error: The following system error occurred: No connection could be made because the target machine actively refused it.

Keith
Go to Top of Page

marco

Netherlands
588 Posts
Posted - 05/08/2009 :  00:31:12  Show Profile  Reply with Quote
Hi,

Did you tried to use also:

XMLA Proxy (OLAP/XmlaProxy.aspx) - XMLA Proxy page reposts data to another web service. To use the proxy page you could use the following URL in the admin > connection page:

ReportPortal/OLAP/XmlaProxy.aspx?url=http://MyOtherServer/xmla/msmdpump.dll&id=user1&pw=password1

----

More info:
http://www.reportportal.com/help/admin/settings.htm

Marco
Go to Top of Page

admin

1637 Posts
Posted - 05/09/2009 :  21:39:41  Show Profile  Reply with Quote
Please try to copy files from: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\isapi
To: C:\Inetpub\wwwroot\xmla
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page