By deafult Analysis server can only be accessed from the local machine. If you want to access it from a remote machine you will have to firstly expose (enable HTTP access to) the analysis server via IIS. You do this by creating a virtual directory in IIS. The detailed process on how to web enable analysis server is given here:
Enable HTTP access on Windows XP
Enable HTTP access on Windows Server 2003
Make sure that you follow the instructions line by line for your operating system. Mostly instructions are same but on Windows Server 2003 you also need to create Web Service Extension. So make your you follow the instruction correctly.
Testing that analysis server is accessible from remote machine
After complteting the instructions mentioned in the articles above you should be able to access analysis server via a web based URL which will be something like http://
Try the URL in internet explorer, if you get some xml results back then great you have successfully accessed the server from remote machine. If you get a page can not be found error then try accessing the URL from Excel. I have experienced issues accessing URL from IE, but it works fine in Excel.
No comments:
Post a Comment