|
jaydog010 -> xmla conecting to remote server help (5 September 2007)
|
Hi everyone
I have been working on this problem for about 2 weeks now trying to read everything I can. It seems that many people have had this issue, but I havent been able to find a solution that works for me. Any help would be greatly appreciated.
Currently we use xmla to connect to analysis services on one server. This works no problem. The problem is that our application relies very heavily on the xmla and we are hitting a major bottleneck and failures because it is used so heavily.
What Im trying to do is remove the xmla from this server and move it to another one. Once that is done I will be able to load balence it. The goal is to have many xmla's serving from the same Anaysis services server.
The problem is that I am having trouble configuring the remote datasource in the datasources.xml file
The two servers sit in the same cabinet and are on the same lan, but are not part of a domain. We are using windows2003 and AS 2000
The configurations I have tried are:
<DataSourceInfo>Provider=MSOLAP.2;Data Source=\\remoteservername\MsOLAPRepository$\msmdrep.mdb</DataSourceInfo>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=\\remoteserverip\MsOLAPRepository$\msmdrep.mdb</DataSourceInfo>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=remoteservername</DataSourceInfo>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=remoteserverip</DataSourceInfo>
each time it was unable to connect to this server. Any help would be great
Thanks
Jay
|
|
|
|
