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

Well, I must install this infra before continue with my tests. I have VMWare
installed, I'll install two Windows 2003 Servers, create a domain, use a
domain account in IIS and see what happens.
The procedure of placing "localhost" on msolap.asp is described in the
document
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_datapump.asp,
and I supposed it should work, but this seems no to be the truth.
I'll try a little bit harder later. Now my problem is another, and I don't
think I can find an easy solution for this:
We use a portal container named "Rainbow", and this portal contains an user
database, and I would like to use these credentials to validate the user in
msolap.asp. I've changed this page code (using shared memory mechanism) to
log all server variables, cookies and session attributes, but there's no
usefull information in that. My guess is that the ActiveX component make
HTTP connection, and this ActiveX does not need to have all this
information.
Can I send some encrypted information to this ActiveX and expect it backs to
ASP page, like a HASH code or something like that?
Should I post a new question for this?

"Dave Wickert [MSFT]" <dwickert@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uNU5zEfcFHA.2288@xxxxxxxxxxxxxxxxxxxxxxx
>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: New Event Log Errors!
    ... Somehow along those lines I'd also installed the Certificate Authority ... Did you apply the last Server Pack for SBS Server? ... Please install Windows Support Tools on the win2k3 sp1 problematic ... Microsoft is providing this information only as a convenience to you: ...
    (microsoft.public.windows.server.sbs)
  • Re: DSO.Server Connect method not responding
    ... Yes I have installed Analysis Services SP3 (AS version is 8.0.760.0 and SQL ... Server 2000 version is 8.00.761). ... > Did u install service pack for Analysis service ...
    (microsoft.public.sqlserver.olap)
  • Re: OLAP Analysis Services Components Installation Help
    ... > My server installed SQL Server 2000 with SP3a, ... > analysis services components, the setup file is runing on Windows ... I am not sure that I can't install olap ...
    (microsoft.public.win2000.security)
  • Re: Cannot activate SBS 2003 SP2
    ... everywhere and sitting on the case of the server is the old board - balanced ... slip stream SBS you would have had it ages ago. ... My main reason for slipstreaming the install is because I cannot get ... updates that need to be applied if one is to have a succesful outcome ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot activate SBS 2003 SP2
    ... everywhere and sitting on the case of the server is the old board - balanced ... slip stream SBS you would have had it ages ago. ... My main reason for slipstreaming the install is because I cannot get ... updates that need to be applied if one is to have a succesful outcome ...
    (microsoft.public.windows.server.sbs)