I have been seeing very slow performance in connecting to a OLAP server
from clients PCs on different machines. Originally I was connecting using
VBA ADO MD, and then i tried Pivot Table Services, and MDX Sample app.,
however, each connection takes 15 seconds so it is not a client's tool delay.

If I use the same application on the OLAP server and connect locally, it
connects in just 1 second.
In the Server i am using Analysis Services 2000 with SP3a over Windows 2000
Server (SP4)... My string conecction has just the provider specification and
the Data Source defined.

Please Help

Regards
Rodrigo

Are all of your clients on high-speed connections with access to trusted
domain controllers? I have seen this kind of thing when there are delays
because of networking infrastructure.

Since AS only supports trusted connections, there will always be this DC
lookup to impersonate the user (unless you've specified SSPI=ANONYMOUS).

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Rodrigo" <Rodrigo (AT) discussions (DOT) microsoft.com> wrote