Koen Verbeeck (3/16/2012)
That's odd. If you installed everything local, Excel should find SSAS just fine.Can you log into SSAS using Management Studio?
ps: to use TCP to connect to SSAS, you just replace the hostname with the following:
TCP:ipAddress,portnumber
Yes, I've been able to connect to Analysis Services from SSMS.
Will you please tell me how to find ipAddress and portnumber?
-