Thursday, March 22, 2012

Accessing Analysis Services 2005 from MS Excel using HTTP from Windows 2000 Server

Hye Friends,
I have installed and configured SQL Server 2005 Analysis Services and MS Office 2000 with the latest Service Packs on Windows 2000 Server. I am able to connect to my Analysis Services from MS Excel using the following URl in Excel ...
http://<ip address>/olap/msmdpump.dll ("olap" being my Virtual Directory)
I was wondering whether I would be able to connect to the same service without using the fully qualified path with only IP-Address... i.e... using only
http://<ip address>
I have been able to implement the above in Windows 2003 Server, but having problems doing the same in Windows 2000 Server. Can anyone help?
Thanks in Advance

How were you able to do so in Windows 2003? I've tried using IIS 6.0 to redirect, but without success.

No comments:

Post a Comment