| T O P I C R E V I E W |
| meo |
Posted - 07/16/2007 : 07:47:53
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>
|
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 07/18/2007 : 19:38:29
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?
|
Report Portal
