I have followed all the steps correctly present i am trying to connect to SSAS 2008 via IIS (HTTP).
My SSAS is on Machine 1. My excel 2010 client is on Machine 2. I have enabled basic authentication for this. I am able to connect SSAS when I am using the credentials of ‘System Administrator’ of Machine 1 (on which SSAS is present). But if I am using any another user then I am able to connect to SSAS.
Is this a limitation with IIS or SSAS? Please share your views, it’s really urgent