Excel 2003 doesn't work with SQL 2005 AS

Greetings!
We have a connectivity problem between Excel 2003 and SQL Server 2005 AS. We
created cubes and it works OK on server. Then we installed Excel 2003 on AS
server to check connectivity. It works OK. But on any other workstation with
Excel installed it could not connect. It shos the message that server is not
available. Please help me if you know the solution.
We have SQL 2005 SP1 and Excel 2003 SP2 installed.
Thank you.
Igor A. ChechetHi Igor,
I'm pretty sure you'll need the most recent OLAP provider for connecting to
AS 2005. It's named "Microsoft OLE DB Provider for Analysis Services 9.0" and
can be downloaded from this here:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
/Martin
"Igor A. Chechet" wrote:
> Greetings!
> We have a connectivity problem between Excel 2003 and SQL Server 2005 AS. We
> created cubes and it works OK on server. Then we installed Excel 2003 on AS
> server to check connectivity. It works OK. But on any other workstation with
> Excel installed it could not connect. It shos the message that server is not
> available. Please help me if you know the solution.
> We have SQL 2005 SP1 and Excel 2003 SP2 installed.
> Thank you.
> Igor A. Chechet
>
>