dbTalk Databases Forums  

Very lazy connecting to AS2000

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Very lazy connecting to AS2000 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jiri Cerny
 
Posts: n/a

Default Very lazy connecting to AS2000 - 08-21-2006 , 06:10 AM






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





Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Very lazy connecting to AS2000 - 08-21-2006 , 07:19 AM






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 (AT) post (DOT) cz> wrote

Quote:
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







Reply With Quote
  #3  
Old   
Jiri Cerny
 
Posts: n/a

Default Re: Very lazy connecting to AS2000 - 08-21-2006 , 07:34 AM



Thanks for suggestion, Jéjé.
I am connectiog using IP adress.
I have tried netbios name too, with the same results.
BTW, all other software but AS runs fast with both IP adress or netbios
name.


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Quote:
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 (AT) post (DOT) cz> wrote in message
news:%23sLHnJRxGHA.1808 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
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









Reply With Quote
  #4  
Old   
Jeje
 
Posts: n/a

Default Re: Very lazy connecting to AS2000 - 08-21-2006 , 06:03 PM



I suspect a network issue.
when the time taken to authenticate is long sometimes the problem come from
a DNS configuration.
double check the DNS config of your server and stations.
the primary DNS server should be your active directory server.
and try a dns name when you connect to your server.


"Jiri Cerny" <j-cerny (AT) post (DOT) cz> wrote

Quote:
Thanks for suggestion, Jéjé.
I am connectiog using IP adress.
I have tried netbios name too, with the same results.
BTW, all other software but AS runs fast with both IP adress or netbios
name.


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:uPAaewRxGHA.4460 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
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 (AT) post (DOT) cz> wrote in message
news:%23sLHnJRxGHA.1808 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
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











Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.