Geek asks and answers

SSAS Access over HTTP

I followed all the steps correctly presented in

http://msdn.microsoft.com/en-us/library/gg492140.aspx

I am trying to connect to SSAS 2008 through IIS (HTTP). My SSAS is on machine 1. My excel 2010 client is on machine 2. I have enabled basic authentication for this. I can enable SSAS when I use the credentials of the "System Administrator" Machine 1 (which has SSAS on it). But if I use another user, then I can connect to SSAS. Is this a limitation with IIS or SSAS? Please share your views, this is really true.

+3
source share
3 answers

. , . , SSAS IIS_IUSERS, SSAS . , , ? .

,

0

, SSAS, ? " " SSAS, SSAS . ( SSAS) , SSAS.

+1

First of all, you do not need to configure SSAS for access through HTTP to connect to it from excel. Why are you doing this?

Secondly, the correct way to access the HTTP cube http://YOUR_SERVER/olap/msmdpump.dllif you upgrade to SSMS on machine 2 and let it know that this connection works?

Third and more important, where is IIS? In the same box as SSAS? If yes, great! If not, you need to set up keberos because you will be dealing with a double jump situation.

0
source

More articles:


All Articles