Re: Very lazy connecting to AS2000

verify your network configuration.

maybe you have a name resolution issue.

do you connect using the netbios name or the DNS name of your server?


"Jiri Cerny" <j-cerny@xxxxxxx> wrote in message
news:%23sLHnJRxGHA.1808@xxxxxxxxxxxxxxxxxxxxxxx
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

  • Very lazy connecting to AS2000
    ... I have problems connecting to AS2000 server over LAN: ... The Connect statement lasts 9 ... both machines are in the same workgroup, ...
    (microsoft.public.sqlserver.olap)
  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)
  • Re: Should I install Certificate Authority to solve these problems ?
    ... You can use IPsec with or without certs from your PKI. ... negotiations to your AD machines or those trusting the ... > In the item 1 below, the tool in use is a HP server management tool (type ... >>> Management is pushing to get Certificate Authority ...
    (microsoft.public.win2000.security)
  • Re: network slows down after SP2 install
    ... the machines updated from W2K still open and read the ... Locate the "Microsoft network server: ... Install SP2 for WIN XP and latest service pack for Office 2003 on ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: network slows down after SP2 install
    ... These machines cannot even run the program locally being disconnected from the server with a local copy of the database. ... Install SP2 for WIN XP and latest service pack for Office 2003 on ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)