I have followed all the steps correctly present in
http://msdn.microsoft.com/en-us/library/gg492140.aspx
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.
My problem is resolved. I don't know weather it's a correct solution or not. I have created few users on machine where SSAS is configured with IIS_IUSERS and now SSAS security is working as expected. Please confirm weather it's a right solution or not? Any comments ahd help is appreciated.
With regards, Avinash Nigam