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

use this to connect to an AS 2005 server. (it was most likely installed
with MS Office)

default. An install package is available as part of the SQL Server 2005
feature pack, which is available at:

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

You will find a link to "Microsoft SQL Server 2005 Analysis Services 9.0
OLE DB Provider" about half way down the page. There are links to the
32bit, IA64 and x64 versions of this provider, you will need to install
the appropriate verson on the client machines.

HTH

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

In article <1140213605.305840.151610 (AT) f14g2000cwb (DOT) googlegroups.com>,
vinayusa (AT) gmail (DOT) com says...

have you apply some security in your cube?
if no, try to create a role and add some users on it.

does remote connections are allowed in AS?

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

Hi HTH,

Thanks for your respone,
It means I need to install this services on all client machines,
and it will not work with oledb for olap providers 8.0.. ok

One more things i want to ask, do we need to migrate the olap
repossitory from analysis servces to sqlserver database in 2005., like
we used to do in sqlserver 2000.

If yes that how we can migrate as i could not find the option migarte
analysis services repository in analysis services 2005........?


Please help me in that.

Thanks again..

Ricky..

No, you do not need to migrate the repository like you used to with AS
2000. AS 2005 stores all its meta data in xml files stored in the data
directory.

Jeje makes another good point in his parallel post. Remote connections
to AS are turned off by default when you install it. You need to go into
the Surface Area Configuration tool and enable them. (But you will still
need the OLEDB 9.0 client)

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

In article <1140282835.974849.322580 (AT) z14g2000cwz (DOT) googlegroups.com>,
vinayusa (AT) gmail (DOT) com says...

Thanks Darren and Jeje,

I did all these(enbaled all services for database and analusis services
and sql browser for remote access) but still I am unable to access the
data from other machine,

I also tried with excel also to creating pivot tablem but i am getting
error
"An error encountred in transport layet"
While i am connecting through execl from other client , I am just
giving server name and not giving as user name and password becuase I
am using default instance........

Please help me out in that.......

Thanks & Regards
Ricky

The transport layer would ne TCP/IP, have you checked that there are not
any firewalls preventing access to the server?

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

In article <1140455511.624057.323850 (AT) z14g2000cwz (DOT) googlegroups.com>,
vinayusa (AT) gmail (DOT) com says...