Re: AS 2005 HTTP access with Basic Authentication

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: AS2k Security with ADOMD.NET
    ... > HTTP ... Is there an equivalent connection string syntax when using the IXMLA ... > virtual directory to use Basic authentication, ... > Please do not send email directly to this alias. ...
    (microsoft.public.data.xmlanalysis)
  • Re: AS 2005 HTTP access with Basic Authentication
    ... > The issue is caused by OLEDB 9.0, who doesn't let the credentials pass ... > user that is known to the server, thus bypassing the basic authentication. ... >>> found another article saying that AS 2005 ignores basic authentication ... >>> 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)
Loading