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" an
d
can be downloaded from this here:
http://www.microsoft.com/downloads/...&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 A
S
> server to check connectivity. It works OK. But on any other workstation wi
th
> Excel installed it could not connect. It shos the message that server is n
ot
> available. Please help me if you know the solution.
> We have SQL 2005 SP1 and Excel 2003 SP2 installed.
> Thank you.
> Igor A. Chechet
>
>sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment