Re: Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines

I have configured it many times using the same steps you have.
I have two comments:
1) In step #4 below, did you configure the virtual directory so that only
BASIC authentication is enabled? You can't use NTLM and Anonymous is
probably not what you want unless you are using a domain account.

However, to be honest, I've never tried the localhost trick to point to
yourself. While it technically might work, that would be the first thing I'd
try and change.

If you do that, make sure that both machines are in the same domain; and
that the BASIC account uid/pwd which you enter is a domain user which is
known to both IIS and AS servers.
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Ravi Ambros Wallau" <nospam@xxxxxxxxxx> wrote in message
news:eQ$4obecFHA.464@xxxxxxxxxxxxxxxxxxxxxxx
> Peter:
> I've:
> 1. Installed Analysis Service SP4;
> 2. Registered msmdpump.dll again;
> 3. Changed the msolap.asp and adding the line pump.ServerName="localhost"
> (I am running both Analysis and IIS on the same machine, only for testing
> purposes);
> 4. Removed the "Anonymous access" from Directory Security tab that is part
> of the properties of MSOLAP virtual directory (where msolap.asp and
> msmdpump.dll) is placed;
> 5. When I try to connect using the MDX sample application, I place the
> values:
> http://localhost/msolap as server address (MSOLAP) is my virtual
> application path. Inside this I've msolap.asp, and below, in provider, I
> specify "MSOLAP; prompt=1".
> 6. When prompted for the user credentials, I put an administrator one;
> 7. When I click OK, the MDX application halts, and my CPU goes to 100%.
> When looking on IIS logs, I see that an average of 20 reqs/sec is made to
> MSOLAP virtual directory.
>
> Seems to be a bug for me. Everything works really fine when using the
> shared memory architeture.
> I use Windows XP Pro with all service packs and updates applied. Is
> there some problem with this operating system?
>
> Thanks,
> Ravi.
>
> "Peter Yang [MSFT]" <petery@xxxxxxxxxxxxxxxxxxxx> wrote in message
> news:$JcKznVcFHA.3052@xxxxxxxxxxxxxxxxxxxxxxxx
>> Hello Ravi,
>>
>> Did you install and configure Data Pump Library as described in the
>> article? Is MSOLAP.ASP working after you changing the servername?
>>
>> Best Regards,
>>
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>>
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>>
>> =====================================================
>>
>> Business-Critical Phone Support (BCPS) provides you with technical phone
>> support at no charge during critical LAN outages or "business down"
>> situations. This benefit is available 24 hours a day, 7 days a week to
>> all
>> Microsoft technology partners in the United States and Canada.
>>
>> This and other support options are available here:
>>
>> BCPS:
>> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
>>
>> Others:
>> https://partner.microsoft.com/US/technicalsupport/supportoverview/
>>
>> If you are outside the United States, please visit our International
>> Support page:
>> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
>>
>> =====================================================
>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>>
>>
>> --------------------
>> | From: "Ravi Ambros Wallau" <nospam@xxxxxxxxxx>
>> | References: <uWNVtCPcFHA.1556@xxxxxxxxxxxxxxxxxxxx>
>> <#5S2cSPcFHA.3204@xxxxxxxxxxxxxxxxxxxx>
>> | Subject: Re: Using MSOLAP throught WEB, but with IIS and Analysis
>> Services on different machines
>> | Date: Tue, 14 Jun 2005 17:41:38 -0300
>> | Lines: 33
>> | X-Priority: 3
>> | X-MSMail-Priority: Normal
>> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
>> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
>> | X-RFC2646: Format=Flowed; Response
>> | Message-ID: <eytVzEScFHA.3404@xxxxxxxxxxxxxxxxxxxx>
>> | Newsgroups: microsoft.public.sqlserver.olap
>> | NNTP-Posting-Host: 200.162.44.2
>> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:12324
>> | X-Tomcat-NG: microsoft.public.sqlserver.olap
>> |
>> | Well, and if it does not works?
>> | I change ServerName on msolap.asp to \\localhost\pipe\PlatoNamedPipe,
>> and
>> | when I run
>> | MDX Sample Application, a lot of requests are made to my http server (a
>> lot
>> | of 200 requests are logged in IIS), and the MDX app hangs...
>> | Is there some trick? I have SP3 installed, it can't be it.
>> | There is no much documentation on internet...
>> |
>> | "Francois Kreutz" <nospam> wrote in message
>> | news:%235S2cSPcFHA.3204@xxxxxxxxxxxxxxxxxxxxxxx
>> | >
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
>> l/sql_datapump.asp
>> | >
>> | > Regards
>> | >
>> | > "Ravi Ambros Wallau" <nospam@xxxxxxxxxx> a écrit dans le message de
>> news:
>> | > uWNVtCPcFHA.1556@xxxxxxxxxxxxxxxxxxxxxxx
>> | >> Hi again:
>> | >> A few days ago, I have asked how to make an OLAP client make a
>> | >> connection thought a browser, and I have made it using a web cast
>> | >> presentation from Microsoft as a guide.
>> | >> Now, my problem is to separate IIS and Analysis Services in
>> different
>> | >> machines. Again, I know it's possible, but can't find how. Does
>> anyone
>> | >> have the solution?
>> | >> Other question: is there some version of MSOLAP.ASP in ASP.NET
>> | >> (MSOLAP.ASPX)?
>> | >>
>> | >> Best regards,
>> | >> Ravi.
>> | >>
>> | >
>> | >
>> |
>> |
>> |
>>
>
>


.

Relevant Pages

  • Re: Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
    ... I must install this infra before continue with my tests. ... log all server variables, cookies and session attributes, but there's no ... > 1) In step #4 below, did you configure the virtual directory so that only ... > SQL BI Product Unit (Analysis Services) ...
    (microsoft.public.sqlserver.olap)
  • RE: Active Sync & OWA probelms
    ... Do you installed ISA server on your ... You have enabled Require SSL on the /Exchange virtual directory. ... In the right pane, click "Connect to the Internet", and then click ... forms-based authentication is required for Exchange Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • RE: Active Sync & OWA probelms
    ... let's focus on the ActiveSync error. ... Do you installed ISA server on your ... You have enabled Require SSL on the /Exchange virtual directory. ... forms-based authentication is required for Exchange Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • Re: Exchange OMA issue
    ... enabled on the server, we do have two connections available, it seemed ... For Exchange-oma virtual directory and the virtual directory you created ... Open IIS Manager ... Exchange Server 2003 SP2 ...
    (microsoft.public.windows.server.sbs)
  • Re: Nokia E50 ActiveSync problem with SBS2003 SP2
    ... Open IIS Manager ... Open properties of virtual directory OMA ... Click Start on your SBS server, ... And then please verify Authentication settings by the following steps. ...
    (microsoft.public.windows.server.sbs)
Loading