Dear All,

I am using sqlserver analysis services 2005. I have installed this on
my local machine with window authentication.
I have create some cubes in analysis services 2005 on my local machine

When I try to connect to cube through excel from my local machine, it
give me 2 options
1. Microsoft OLE DB provider for olap services 8.0
2. Microsoft OLE DB provider for Analysis services 9.0

If I used 2 option i am able to access the cube
when i used 1st option, it gives me the follwoing error:
"Unable to open the connection . cannot connect to the server
'wit-ws2', the server is either not started or too busy"

When I try to connect to cube through excel from any other machine
it give me 1 option
Microsoft OLE DB provider for olap services 8.0

I am getting the follwoing error:
"Unable to open the connection . cannot connect to the server
'wit-ws2', the server is either not started or too busy".
I think i am doing some silly mistake.

Please help in that

Thanks
Vinay

You need to install the 9.0 OLE DB provider on the client machine. It can be
downloaded and installed from here:

http://www.microsoft.com/downloads/d...DisplayLang=en

"Feature Pack for Microsoft SQL Server 2005 - November 2005"

Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

Thanks,
Akshai

--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"RICKY" <vinayusa (AT) gmail (DOT) com> wrote