ADOMD.NET Remote Server

From: Andrew (android1019_at_hotmail.com)
Date: 03/05/04

  • Next message: Stefan: "Re: Limit customer access?" 
    Date: Thu, 4 Mar 2004 16:04:27 -0800

    Our development environment requires us to separate XML
    for analysis service from the Analysis server. I know the
    performance issues associated with doing that via HTTP
    connection (ie. the serialization). We will use an HTTPS
    connection later in development but for now we need to
    have an HTTP connection for testing and proof of concept.
    I am having a hard time getting a connection to a remote
    Analysis server.

    I'm using ADOMD.NET and here is how I set up my
    connection string:

    AdomdConnection conn = new AdomdConnection
    ("DataSource=http://localhost/xmla/msxisapi.dll;Catalog=Fo
    odMart 2000;");

    My datasources.xml looks something like this:
    <DataSource>
       <DataSourceName>Remote Analysis Server</DataSourceName>
       <DataSourceDescription>Microsoft Analysis Server 2000
    on remote machine</DataSourceDescription>
       <URL>http://localhost/xmla/msxisapi.dll>
       <DataSourceInfo>Provider=MSOLAP.2;Data
    Source=10.10.1.121;Initial Catalog=PRM</DataSourceInfo>
       <ProviderName>Microsoft XML for Analysis</ProviderName>
       <ProviderType>
          <TDP/>
          <MDP/>
          <DMP/>
       </ProviderType>
       
    <AuthenticationMode>Unauthenticated</AuthenticationMode>
    </DataSource>

    Running this will give me an error: "A connection with
    the server could not be established". How do I configure
    this correctly?

    Andrew.

  • Next message: Stefan: "Re: Limit customer access?"

    Relevant Pages

    • Re: Tuning for IIS and ADOMD.NET
      ... Are there some good ways sto push the load on to the Analysis Server? ... This pushes some of the processing over to the Analysis Server, ... running 20 mdx queries per page using a single connection object. ... make 20 calls to an Analysis Services Cube? ...
      (microsoft.public.data.xmlanalysis)
    • "Unable to open connection. Unspecified error"
      ... I tried to establish a connection to the analysis server in Excel PivotTable after VPN is connected, ... Select External data source> Next ... It only happends when VPN is connected. ...
      (microsoft.public.sqlserver.olap)
    • Re: Connecting to Analysis Server across domains
      ... If you don't care about security, i.e. cubes are open to everybody - you can ... > I want to connect to the analysis server across domains. ... So for these users connection to the ... > downsides of using anonymous login. ...
      (microsoft.public.sqlserver.olap)
    • RE: Analysis Service for Web
      ... If you are trying to connect to Analysis Server 2000 by using HTTP Connection... ... Then you will need Enterprise Edition of Analysis Services... ...
      (microsoft.public.sqlserver.olap)
    • Re: Cant See Tables in Cube Editor in MS Anaylsis Services
      ... stopped the analysis server and then restarted the service, ... > schema of the data source. ... So if you have a problem in the connection you ... > are not able to see tables and view structure in dimensions and cubes. ...
      (microsoft.public.sqlserver.olap)