When trying to connect to a SQL 2005 OLAP service from Excel 2003 the
following error message is displayed.

Unable to open connection.
Cannot connect to server 'mysql2005'.
OLAP server error: The operation requested failed due to network
problems.

I am logged in with an account that has administrator privilages on the
SQL Server.

Does this require some additional server configuration of the install
to allow remote access to the olap service?

If you are trying to connect from a remote machine, you will need to
install the OLAP provider on this machine.

You can find the provider for AS 2005 on the feature pack page at:

http://www.microsoft.com/downloads/d...d09c1d60-a13c-
4479-9b91-9e8b9d835cdc&displaylang=en

under the heading called "Microsoft SQL Server 2005 Analysis Services
9.0 OLE DB Provider"

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1134058152.228015.318830 (AT) f14g2000cwb (DOT) googlegroups.com>,
robin9876 (AT) hotmail (DOT) com says...