ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

Can't connect to Analysis Server

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Smilies

[quote][i]Originally posted by RobertL[/i]
[br]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
[/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
RobertL	Posted - 10/22/2004 : 06:45:26 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
1 L A T E S T R E P L I E S (Newest First)
admin	Posted - 10/25/2004 : 19:42:06 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.

ReportPortal