Re: Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
- From: "Ravi Ambros Wallau" <nospam@xxxxxxxxxx>
- Date: Wed, 15 Jun 2005 17:16:54 -0300
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.
> | >>
> | >
> | >
> |
> |
> |
>
.
- Follow-Ups:
- Re: Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
- From: Dave Wickert [MSFT]
- Re: Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
- References:
- Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
- From: Ravi Ambros Wallau
- Re: Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
- From: Francois Kreutz
- Re: Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
- From: Ravi Ambros Wallau
- Re: Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
- From: Peter Yang [MSFT]
- Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
- Prev by Date: Connection problems using Linked Server with OpenQuery to access Analysis Server
- Next by Date: Re: Connection problems using Linked Server with OpenQuery to access Analysis Server
- Previous by thread: Re: Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
- Next by thread: Re: Using MSOLAP throught WEB, but with IIS and Analysis Services on different machines
- Index(es):
Relevant Pages
|
