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

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Can't connect to Analysis Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

RobertL

1 Posts

Posted - 10/22/2004 :  06:45:26  Show Profile  Reply with Quote
When I try to create an OLAP report I get the error message "An error occurred while processing the request". My guess is that there is a problem with my datasources.xml.

<?xml version="1.0" ?>

<DataSources UnnamedSessionsTimeout="300" NamedSessionsTimeout="3600" MaxRequestSize="128" AllowInsecureTransport="1" EnableNagleAlgorithm="1">
<DataSource>
<DataSourceName>ROBERTL</DataSourceName>
<DataSourceDescription>My Analysis server</DataSourceDescription>
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=ROBERTL</DataSourceInfo>
<ProviderName>Microsoft XML for Analysis</ProviderName>
<ProviderType>
<TDP/>
<MDP/>
<DMP/>
</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
</DataSource>

</DataSources>

Where ROBERTL is the name of my Analysis Server. I'm pretty sure that all security settings are OK. Does anyone have any ideas of what the problem is?

Thanks

admin

1647 Posts

Posted - 10/25/2004 :  19:42:06  Show Profile  Reply with Quote
First try recommend watching this installation video: [url]http://www.reportportal.com/Flash/Install.html[/url]

XMLA SDK 1.1 requires MSXML 4.0. It can be downloaded by clicking here [url]http://www.microsoft.com/downloads/details.aspx?FamilyID=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&DisplayLang=en[/url].

When installing XML for Analysis SDK 1.1 don't forget to: Change the execute permissions for the "XMLA" virtual directory to "Script and Executables". Change msxisapi.dll to use anonymous authentication with a user account that has full access to the Analysis Services.

Try using the SDK sample application to make sure that XMLA SDK is properly installed.

You can also test the connection with this page MDX.htm. [url]http://www.reportportal.com/MDX.htm[/url]. Please save this page to desktop before running it. Sometime it is necessary to restart the IIS service or the PC for the XML/A web service to work.
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