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

Hello Ravi,

Since AS is based on Windows authentication, formed based authentication
does not work directly under this situation. We need to use Windows
integrated or basic authentication on IIS.

If you want to use form based authentication, usually you need to enable
Anonymous authention in IIS, use your own code to mange/autheticate
users/permssions in ASP page, and then impersonate a domain or local
Windows user so that you could connect to Analysis Server. The following
articles are for your reference:


HOWTO: Impersonate a User from Active Server Pages
http://support.microsoft.com/default.aspx?scid=kb;en-us;248187

299984 How To Use ASP to Retrieve Authentication Information About Web
Users in
http://support.microsoft.com/?id=299984

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.

=====================================================


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>
<eytVzEScFHA.3404@xxxxxxxxxxxxxxxxxxxx>
<$JcKznVcFHA.3052@xxxxxxxxxxxxxxxxxxxxx>
<eQ$4obecFHA.464@xxxxxxxxxxxxxxxxxxxx>
<uNU5zEfcFHA.2288@xxxxxxxxxxxxxxxxxxxx>
| Subject: Re: Using MSOLAP throught WEB, but with IIS and Analysis
Services on different machines
| Date: Thu, 16 Jun 2005 13:44:56 -0300
| Lines: 189
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-RFC2646: Format=Flowed; Response
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| Message-ID: <e67m2JpcFHA.2664@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.olap
| NNTP-Posting-Host: 200.162.44.2
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:12413
| X-Tomcat-NG: microsoft.public.sqlserver.olap
|
| 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/htm
l/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: WIN2K3 Server and WIN2K Pro Browser Issue
    ... this is more of a FPSE question than an IIS question. ... The repeated 401.1 when you have Integrated Authentication ... > What version of FrontPage Server Extensions are you running on the server? ... Windows 2000 Pro computers ...
    (microsoft.public.inetserver.iis.security)
  • RE: Beginners Questions
    ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Combining Anonymous + Integrated Windows auth
    ... I changed the http error page for 401.2 in Custom Errors in IIS to ... I'm hoping I can use the aspx page so I can use my server side ... > Note that windows integrated authentication is NOT securely encrypted ...
    (microsoft.public.inetserver.iis.security)
  • Re: WM5 can not sync to exchange
    ... I checked all the authentication settings and they are as you requested. ... After running the internet connection wizard I had to uncheck the Require ... On the SBS 2003 Server open the Server Management console. ... Open IIS Manager ...
    (microsoft.public.windows.server.sbs)
  • Re: IIS Start up errors
    ... provide the detailed steps to reinstall the IIS server in SBS 2003 server. ... For example, programs such as Microsoft ... In the Currently installed programs list, click Windows Small Business ...
    (microsoft.public.windows.server.sbs)