How to configure SSAS 2005 for use with Excel

Using Excel I can connect to SSAS on localhost, but when I try to do the same from another computer, I can't connect to the server.

What can I configure to allow this connection ?

I already disactivated the firewall and I added a role to the cube that I want to use. But the connection error occures when listing the cube present on the server. I don't know what I can change now....

Thanks for your help.

hello,

Try downloading the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider from the below link and try connecting it . It worked for me .

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

Check the Content in Microsoft SQL Server 2000 PivotTable Services for details

regards

varadaraj