Hello,


We have a setup where a webserver queries data of AS.
Currently we have to connect with a HTTP connection due to
slow response of a direct IP connection. We would like to
use the IP connection, however as performance seems
better -- when it is working.

Here is the problem:

Using a connectionstring which points directly to an IP
may work for a while but after some time each connection
(which would happen once per page) takes between 15 and 20
seconds. Mind you, it is not the query taking up this
time, but the execution of the Open() method itself.

Here are some facts, which may matter:

-Web server located physically near AS server (two
separate servers)
-100mbit connection between the two (and plenty of
available bandwith)
-AS server is pretty powerful: 4GB of memory, 1 xeon
processor.
-neither of the servers are in a windows domain.
-slowdown independent of cube size and database.
-all other traffic between the two is fast.

Connectionstring (local ip address):
Provider=MSOLAP.2;Data Source=10.10.10.109;Initial
Catalog=ilead

- i tried with the computername as well, by the way.

I have seen posts about this on the web, but never found
an answer.

Hope someone is going to be able to help!

Thanks.


/Martin

So how do you authenticate against Analysis Services ?
Usually, slow opening connection can be traced to roundtrips to the domain
controller. If by using HTTP you switch to the anonymous authentication,
then you could do the same with TCP/IP by adding SSPI=anonymous to the
connection string.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Hi,


That seems to do the trick!

It has been running for 4 days without problems now
(before without sspi=anonymous it ran ok for a few hours
and then slowed down). Strange problem, I think, but
delighted that it works! :-)

Thanks a million!


/Martin