Hi,
I am trying to access a cube over HTTP, which I can get working when
everything is done from the same domain.
The setup I'm having problems with is: IIS with msolap.asp and msmdpump.dll
registered. I've added the pump.ServerName = "xxx.xxx.xxx.xxx" to the asp
page.
Authentication is set to basic and disabled anonymous. This is all on
domain x. When I am on domain Y, I try to add a pivot table in Excel to
access the cubes. I am using the http addr of the IIS box and passing in my
credentials for the X domain. The problem is its timing out or just not
connecting at all. Has anyone had success with this or a similar setup?

Thanks,
Brian

Hello Codecommando,
you will need to ensure that there is a trust setup between the domains x
and y
if this is not possible you options are limited to mapping accounts with
the same username and password.
I may be wrong but I don't believe kerberos will help in this scenario

Hey,
Over the weekend, I did get this working for the case where both AS and IIS
are on the same box on the second domain. So now when I connect to the AS
server with the http:// address as the connection string it will connect and
work. I did this to verify that I can connect across domains.
I still haven't found a solution for the case where AS is on one server and
IIS is on a second with the msolap.asp modified with the pump.servername set
to the AS box.
Any ideas?



"BigJimSlade" wrote:

In that event, it is probably a delegation problem.
What type of security are you running on the virtual directory? It cannot be
NTLM, it must be basic or anonymous. If you try NTLM you will get into a
two-hop situation, which cannot be done using NTLM. For two-hop you must run
kerberos.
--
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.


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

I've tried it with basic and anonymous(neither worked). I even tried setting
the anonymous user to administrator (just to see!!!) but nothing.
My next step is to try using kerberos.
BTW, do I need to have IIS on the AS box if I am hitting the dedicated IIS
server?
(At my wits end here!!!)

Thanks,
Brian

"Dave Wickert [MSFT]" wrote: