Re: MSMDPUMP.DLL Peformance

Tech-Archive recommends: Fix windows errors by optimizing your registry

Akshai,

You are right on the mark. We changed our backend to use NTLM and Kerberos
to the AS 2005 server and the issue was resolved.

Thanks, for your response.

Bill


"Akshai Mirchandani [MS]" <akshaim@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uUir5g2VGHA.5200@xxxxxxxxxxxxxxxxxxxxxxx
This behavior is standard for HTTP authentication -- the first request
attempts to connect without security and fails indicating that
authentication is required. The second request then contains the
authentication information...

Pre-authentication skips the first step when a username/password is
specified. PTS 9.0 does not do pre-authentication -- primarily for
security. Basic authentication is inherently insecure and users sometimes
enter usernames/passwords even when connecting over NTLM -- so PTS doesn't
send the credentials until the server responds that it really does need
Basic auth credentials.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.

"Bill Hays" <bhays@xxxxxxxxxxx> wrote in message
news:eJtYBZ1VGHA.5148@xxxxxxxxxxxxxxxxxxxxxxx
Akshai,

We have had some more time to diagnose, so here are some details.

The msmdpump.dll first attempt always gives web error 401.2
win32(2148074254) but the second (which includes the authentication
information) is successful.

We noticed that a second web service applcation we wrote, running on the
same server was having the same problem until we enabled pre-authenticate
on the web service client proxy.

Is there some way in PTS 9.0 to configure the same type of
pre-authentication?

Also, we are using basic auth because the Web server and SSAS server are
different computers, and I didn't want to setup kerb auth. it's a
private DMZ back-end network, and we are using https on the front end
anyway, so basic auth has been our direction.

Thanks,

Bill


"Akshai Mirchandani [MS]" <akshaim@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:eY2kHePVGHA.4436@xxxxxxxxxxxxxxxxxxxxxxx
Can you explain in a little more detail this underlying authentication
protocol issue? Does it appear to occur only with Basic authentication?

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no
rights
Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.

"Bill Hays" <bhays@xxxxxxxxxxx> wrote in message
news:uR4njXNVGHA.5900@xxxxxxxxxxxxxxxxxxxxxxx
Hello everyone,

I have been having MSMDPUMP.dll performance issues, and after some
deeper investigation perhaps found an underlying authentication
protocol issue. The result of this issue causes a 2X increase of
overall communications.

Has anyone else had success using the pump with Basic Authentication?
Perhaps there is some server or .ini setting I am missing?

Thanks,

Bill









.

Relevant Pages

  • Re: ADFS Development Issues
    ... site to be automatically authenticated by our windows application so ... based on redirects and possibly uses forms-based authentication to collect ... web service proxies don't handle this type of thing ... the server based on how it needs to work. ...
    (microsoft.public.windows.server.active_directory)
  • RE: WSE 2.0, smart client, Username authentication, no x.509
    ... web services WSE 3.0 hosts them without a web server for you (read the WSE ... To perform authentication, because your database does not contain user ... the implementation William Stacey has uses Security ... > server where my web service is ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: Issues w/Web Service
    ... server server, the process need a primary token. ... to other network services as that user. ... >I have a web service configured with Anonymous access disabled. ... > that the web service authentication use, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Pass through credentials to web service
    ... It is the double-hop' limitation of NTLM authentication. ... application server, the server cannot then use those credentials to ... >I have a client application that calls a web service. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: a web service to log in to a image application server
    ... I don't know how it would be handled client side using PHP. ... You could also reuse a known authentication scheme. ... The image server is used to stored image documents requiring ... If I develop a web service to authenticate log in to ...
    (microsoft.public.dotnet.framework.aspnet.webservices)