Re: HTTP Access to AS 2005 not working

In article <E81223C9-A241-4B5C-8EB0-8397A3858C3C@xxxxxxxxxxxxx>,
pat@xxxxxxxxxxxxx says...
> The problem occurs on the server. I shouldn't have to have "prompt=1" in the
> OWC connection string, since I've authenticated myself to IIS.
>
> The prompt=1 causes OWC to ask for authentication again. This shoudn't be
> necessary, and will prevent any client from connecting to the AS. And yes,
> the clients have OLEDB 9 installed.
>

I have not tried to use basic authentication with AS, but I might have
and idea why you have to authenticate twice.

What I think might be happening in this scenario is that the user
authenticates to IIS and it sends down a web page which has code in it
referring to the OWC ActiveX control. OWC then fires up and makes it's
own connection to AS. What some people do not realize is that OWC is a
client side technology, it uses PTS on the client to connect back to AS
and execute queries.

Can you try turning off basic authentication on the website that is
serving the pages and just leaving basic authentication on the virtual
folder containing msmdpump.dll?

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
.

Relevant Pages

  • Re: IIS 6.0 and 401.2 and 401.1 Errors
    ... > authentication -- client and server first negotiate authentication that ... > So, if you see repeated 401.2 for the same resource from the same client, ... > authenticated connection and instead RENEGOTIATING a new connection. ... > You can easily verify this by installing "Network Monitor" from Windows ...
    (microsoft.public.inetserver.iis)
  • Re: IIS 6.0 and 401.2 and 401.1 Errors
    ... authentication -- client and server first negotiate authentication that ... authenticated connection is considered "authenticated" and directly succeed. ... So, if you see repeated 401.2 for the same resource from the same client, it ... means that the client and server are NOT keeping their previously ...
    (microsoft.public.inetserver.iis)
  • Re: Problem connecting to SSH, OpenVMS7.3-2, HP TCP/IP v5.4 patched
    ... debug: ... connection lost. ... client on the same node as the server. ... [No surprise, as I allow, but don't use, host-based authentication.] ...
    (comp.os.vms)
  • RE: Windows Me/98 Client connecting to SQL W2k3
    ... because to simplify the connection problem it can also be ... On Wednesday I will be at the client site and I will check the MDAC and the ... SQL authentication we do not use. ... Only Windows Authentication. ...
    (microsoft.public.sqlserver.connect)
  • Re: IIS 6.0 and 401.2 and 401.1 Errors
    ... > So, if you see repeated 401.2 for the same resource from the same client, it ... > authenticated connection and instead RENEGOTIATING a new connection. ... > this unnecessary renegotiation that is causing extra authentication trips ... > Server 2003 Add/Remove Programs, Windows Components and then watch the ...
    (microsoft.public.inetserver.iis)
Loading