I have a Windows Server 2008. It has SQL Server 2008 Standard Edition installed. We have IIS 7.0 on the server. My intention is to access the SSAS Database without Windows authentication. The user outside the domain should be able to access the cube and built PIVOT tables around it.
I followed each and every step mentioned on the following links
[login to view URL]
[login to view URL]
Then also its not working. In the excel when I connect "Analysis services" give the servername as "http://localhost/olap/[login to view URL]" and the windows username and password at the server. Giving errors. I would like a person experienced with IIS 7 and have done this before to help me out.
This project would involve guiding me through Skype in troubleshooting the issues in successfully establishing HTTP connection to SSAS 2008.
Please let me know if there are any questions.