Re: AS 2005 HTTP access with Basic Authentication

It means that I have authenticated to IIS with basic authentication. When the
client navigates to the page containing the OWC control, IIS requests the
userID+pwd for basic authentication.
With AS2000 that's all you need. The subsequent connection from OWC to
AS2000 is done using this authentication token.

With AS2005, you're suggesting to add a "prompt=1" in the OWC connection
string. What happens is the following: User navigates to the page containing
the OWC control and IIS requests the userID+pwd for basic authentication, as
above.
When connecting OWC to AS2005 though, the prompt=1 causes you to enter your
userID+password once again. This means that the previous authentication to
IIS is completely bypassed.
You have to do that because OLEDB 9.0 and AS2005 are not able to work the
way OLEDB 8.0 and AS2000 did. They cannot use the IIS token.

In my opinion, this is the reason why you cannot connect to AS2005 from
Excel, whichever way you try (even the prompt=1 cheat doesn't help) unless
client and server are in the same domain.


"Edward Melomed [MSFT]" wrote:

> Hi Pat.
> I was looking at your previous postings and it is bit hard to understand
> what is going on in your situation.
> When you are saying that you alreday authenticated to IIS , what does that
> mean?
>
>
> "Pat" <pat@xxxxxxxxxxxxx> wrote in message
> news:8E504CDE-4FEA-436B-BD3C-676D555B6345@xxxxxxxxxxxxxxxx
> > Come on Edward, there are several posts on this newsgroup documenting that
> > HTTP with Basic Authentication doesn't work on AS2005.
> > I have a support incident open for 3 weeks and counting about this, and I
> > saw somebody else on this newsgroup with another support incident still
> > open.
> > The issue is caused by OLEDB 9.0, who doesn't let the credentials pass
> > from
> > IIS to AS2005.
> > It probably works on your own workstation because you are signed in as a
> > user that is known to the server, thus bypassing the basic authentication.
> >
> >
> > "Edward Melomed [MSFT]" wrote:
> >
> >> Once you enabled the Basic Authentication you need to make sure you
> >> specify
> >> your credentials.
> >> You can do it ever by specifying "user" and "password" connection string
> >> properties in your connection string.
> >> Or you can add "prompt=1" to your connection string and you will get
> >> additional dialog asking for your credentials.
> >>
> >>
> >> Edward Melomed
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >>
> >> "Scott Ivey" <iveys@xxxxxxxxxxxxx> wrote in message
> >> news:3B651890-487C-4A78-B1DB-635E99C12C3F@xxxxxxxxxxxxxxxx
> >> > Hi all - hopefully someone here can help me out with this. I have an
> >> > open
> >> > ticket on this with MS as well, and none of their techs seem to know
> >> > how
> >> > to
> >> > help me. I have enabled HTTP access to our Analysis Services 2005
> >> > server
> >> > by
> >> > following the steps at
> >> > http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx -
> >> > however, I need to use BASIC AUTHENTICATION instead of Windows
> >> > Integrated.
> >> > Once I enable basic and disable integrated, everything just stops
> >> > working.
> >> > I
> >> > found another article saying that AS 2005 ignores basic authentication
> >> > by
> >> > default, and gives steps to change the setting, but the screen that
> >> > they
> >> > talk
> >> > about doesn't exist, and the one that does that looks similar doesn't
> >> > list
> >> > the properties necessary to change. Link to that article is...
> >> > http://msdn2.microsoft.com/en-us/library/ms174573.aspx. It says the
> >> > following - "Based on the default setting of 1, Analysis Services
> >> > rejects
> >> > client requests that are submitted by using Basic authentication. To
> >> > accept
> >> > client requests that use Basic authentication, change the setting for
> >> > this
> >> > property to 0." I tried to add the property directly thru msmdsrv.ini
> >> > file,
> >> > but that didn't seem to work either. Anyone else have any other ideas?
> >> > I'm
> >> > desperate here - I'm supposed to be on vacation tomorrow, and if I
> >> > don't
> >> > have
> >> > this fixed by then, i'm in deep $*%!.
> >> >
> >> >
> >> > Thanks!
> >> >
> >> > Scott Ivey
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: AS 2005 HTTP access with Basic Authentication
    ... Pat - I agree with you that its a bigger problem. ... My current problem is that OWC hosted in my ... > It means that I have authenticated to IIS with basic authentication. ...
    (microsoft.public.sqlserver.olap)
  • RE: OMA Error 1503
    ... Basic Authentication is the only checkbox selected for the OMA VD. ... Re-run the CEICW on your SBS box and ensure Outlook Mobile Access is ... Install MBExplorer by installing IIS 6 Resource Kit Tools: ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Newbie question: Basic auth works, Chall/Resp fails?
    ... Subject: Newbie question: Basic auth works, Chall/Resp fails? ... patched up to date and IIS 4. ... I'm not worried about the clear text issue that Basic authentication ... > account domain and normally authenticates against ...
    (microsoft.public.inetserver.iis.security)
  • Re: Passing credentials
    ... > I have two web sites on the same IIS ... > server. ... Site B is set with 'Basic Authentication' mode. ... Tom Kaminski IIS MVP ...
    (microsoft.public.inetserver.iis.security)
  • Re: IIS With Basic Authentication Set/FormsAuthentication - HELP PLS!?
    ... IIS does... ... When you use Forms authentication you have to set IIS to Anonymous ... > Basic Authentication set. ... > again, trying to avoid the browser prompt, and add the authentication to ...
    (microsoft.public.dotnet.security)
Loading