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
 XMLA - wrong catalog -
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

meo

Germany
25 Posts

Posted - 07/16/2007 :  07:47:53  Show Profile  Reply with Quote
hello,

i have two Servers
1) Live Server ( Name: Server_live)
2) developer with cubes (Name; Server_dev)

On Server Nr. 1 (Server_live) ist Reportportal installed.

When i want to go on the cubes on Server_dev(2) i get allways the catalog from Server_live (1)

the only way to get the right catalog, is to cut the connection information in the config file for xmla.
Is there a wrong caching ?



my config file for xmla:

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


<DataSource>
<DataSourceName>Dev Server</DataSourceName>
<DataSourceDescription></DataSourceDescription>
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=Server_dev</DataSourceInfo>
<ProviderName>Microsoft XML for Analysis</ProviderName>
<ProviderType>
<TDP/>
<MDP/>
<DMP/>
</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
</DataSource>


</DataSources>

admin

1645 Posts

Posted - 07/18/2007 :  19:38:29  Show Profile  Reply with Quote
It seems that that you have troubles connecting from a web server (Server_live) to Analysis Services on another server (Server_dev).

It is important that

1) Both servers belong to the same domain or workgroup
2) The anonymous user for XMLA virtual directory has full access to Analysis Services on the other server.

Are you able to connect to the remote AS server by removing the entry to the local AS server in datasources.xml file?
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