Very lazy connecting to AS2000



Hello everybody,

I have a very depressing and very urgent problem, please help.

I have problems connecting to AS2000 server over LAN: the Connect statement
lasts 9 seconds.
Simply 9 seconds - never less, never more.
I thought that the reason is ADOMD net client, but the same problem appears
even if I connect from MDX Sample Application. The Connect statement lasts 9
seconds, then everything works fine and very fast.
(In fact, from MDX Sample App, only the first Connect lasts 9 seconds; the
second and every subsequent Connect lasts only 4 seconds. But I think it is
too much as well.)

The configuration is:
"server": Win2003 server standard edition + SP1, SQL2000 + AS2000 + SP4
installed,
"client": Win2003 server standard edition + SP1, SQL2000 + AS2000 + SP4
installed
(I run MDX Sample App on the "client" and connect to the "server"),
both machines connected with fast Ethernet (1Gb),
both machines are in the same workgroup (no domain),
I am in Administrators group on both servers (with the same user name &
password).

During the Connect statement processor is idle on both machines, and there
is almost no disc activity.
If I connect locally, it's almost immediately (about 0.1 s).
Everything other is very fast (e.g. ping from "client" to "server" <1ms,
Connect network drive & browse with no noticeable delay, log-in with RDC
client very fast).
Seems that the problem is related to AS2000 only.

One interesting thing: if I connect from "server" to the "client" (with MDX
Sample App), it is almost instantly.
But unfortunately, I need to connect from "client" to "server".

Thanks for any ideas.

Jiri Cerny




.



Relevant Pages

  • Re: Very lazy connecting to AS2000
    ... verify your network configuration. ... I have problems connecting to AS2000 server over LAN: ... The Connect statement lasts ... both machines are in the same workgroup, ...
    (microsoft.public.sqlserver.olap)
  • Re: Kerberos to NTLM delegation timeout
    ... Logging out complete typically lasts about 24 hours. ... All Windows Server 2k3. ... inconsistent times of the day. ... an NTLM ticket causing a double hop failure. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Crysis demo available now for EA Store preorders
    ... for some reason most of jonah falcon's threads don't show up on my news ... server. ... plays almost exactly like far cry, so anyone who didn't like far cry can ... you're crouching or prone it lasts a lot longer. ...
    (comp.sys.ibm.pc.games.action)
  • Re: xntpd hanging
    ... it lasts about 10 seconds before hanging and not responding to any requests. ... server uk.pool.ntp.org ... Do you have any sort of "change control" process that would tell you what changes were made between the last time you know it worked and the first time you noticed it was broken? ...
    (comp.protocols.time.ntp)
  • Re: xntpd hanging
    ... On one of our AIX 5.3 boxes, xntpd isn't very happy. ... it lasts about 10 seconds before hanging and not responding to any requests. ... server uk.pool.ntp.org ...
    (comp.protocols.time.ntp)