• 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?

    -