Re: AS 2005 HTTP access with Basic Authentication

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
    ... Or you can add "prompt=1" to your connection string and you will get ... additional dialog asking for your credentials. ... I need to use BASIC AUTHENTICATION instead of Windows Integrated. ... > client requests that are submitted by using Basic authentication. ...
    (microsoft.public.sqlserver.olap)
  • Re: Single Sign on Between IIS 6 and IIS 5
    ... The HTTP standard for Basic authentication ... automatically forward Basic credentials when users establish a connection to ... Forwarding credentials outside the protection space of one authenticated ... site can be implemented with Microsoft Active Server Pages and/or HTML ...
    (microsoft.public.inetserver.iis.security)
  • Re: AS 2005 HTTP access with Basic Authentication
    ... If you are inside Internet Explorer and browse to a web page and specify ... would work without demanding the basic authentication credentials again. ... >> It means that I have authenticated to IIS with basic authentication. ...
    (microsoft.public.sqlserver.olap)
  • Re: Basic Authentication
    ... IE does not (by default(send credentials automatically when Basic Authentication is used, even if the site is in the Intranet zone. ... credentials to IIS without prompting for it. ...
    (microsoft.public.inetserver.iis.security)
  • PreAuthenticate doesnt work
    ... We are having problems trying to send HTTP Basic Authentication credentials in the first message. ... Usually they're not sent in the first message, then the server issues a challenge, then the client sends another message with the credentials. ... We badly need to be able to do this do use a .NET client for a web service implemented on a Cape server, that doesn't seem to issue a challenge. ...
    (microsoft.public.dotnet.framework.webservices)
Loading