I'm trying to connect to SQL Server 2005 Analysis Server, but I'm always
getting this error:

Unable to connect to the selected cube.
Error message: Cannot connect to the server 'localhost'. The server is
either not started or to busy.

Any help in this issue will be highly appreciated.

Thanks

You are trying to connect to the analysis server on you local machine?
You ofcourse checked that the analysis service is running?

Nc

"UR" wrote:

Yes, I checked in both the places, in SQL Computer Manager and Services, its
running and started in both places. Does it has to do something with the
Provider, I'm using "Microsoft OLE DB Provider for OLAP Services 8.0." and
the Analysis Server is installed in Windows 2003 server.

Thanks

"verbani" wrote:

That will be the problem.
If you are trying to connect to the 2005 AS you need to use 9.0 provider.

Regards,
Nico

"UR" wrote:

From where do I get 9.0?

"verbani" wrote:

The machine you are connecting from isn't the same as the machine you have
the AS installed on?

Normally then it should be installed automatically.
If I'm not mistaking if you install the PTS of 2005 it also contains the 9.0
provider.

PTS is a part of the AS.

Regards,
Nico

"UR" wrote:

Folder: \\SQL 2005 June CTP\Redist\Analysis Services\PTS9.msi

I think this should do the trick

"UR" wrote:

The machine to which I'm connecting has "Microsoft OLE DB Provider for
Analysis Services 9.0", but when I use that, it gives me the connection
issue. I tried to connect using OWC in my asp.net page, and also I downloaded
a trial version of a CUBE Browser, from both I'm getting the same message,
"Provider not found".
Secondly I couldn't find the PTS in SQL Server 2005 beta 2 cd, does it has a
different name. Do I have to install Office XP or Office 2003?


"verbani" wrote:

I need to download the June version.

"verbani" wrote:

It is available to the general public via this link:
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
You can either download it directly from there, or you can order a DVD, or
pointers to other locations, such as if you can find someone in your company
with a MSDN Universal or Professional subscription.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"UR" <UR (AT) discussions (DOT) microsoft.com> wrote