xmla conecting to remote server help

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

xmla conecting to remote server help

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Ask XML questions here] >> .NET programming discussions >> xmla conecting to remote server help

Page: [1]

Message

<< Older Topic Newer Topic >>

xmla conecting to remote server help - 5 September 2007

jaydog010

Posts: 1
Score: 0
Joined: 5 September 2007
Status: offline

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

< Message edited by jaydog010 -- 5 September 2007 >