Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Can't connect to AS 2005 cubes

  
   Database Forums (Home) -> OLAP RSS
Next:  Connection problem  
Author Message
Randy Knight

External


Since: Oct 03, 2005
Posts: 8



(Msg. 1) Posted: Thu Oct 06, 2005 3:48 pm
Post subject: Can't connect to AS 2005 cubes
Archived from groups: microsoft>public>sqlserver>olap (more info?)
I've read here and elsewhere that older OLAP clients (such as Excel
2003) can connect to AS 2005, but without support for new features. I
can't seem to get anything to connect to my AS 2005 box. I'm running
the September CTP on both the server and the workstation I'm trying to
connect with. The odd thing is it will connect to the server and let
you pick a database but doesn't go any further than that.

I've installed the beta of ProClarity 6.1 so I can use that but I want
to use Reporting Services 2000 and can't get that to work. Also tried
Excel 2003 ... no dice their either.

Anybody else seen this and if so, how did you resolve it?

 >> Stay informed about: Can't connect to AS 2005 cubes 
Back to top
Login to vote
Randy Knight

External


Since: Oct 03, 2005
Posts: 8



(Msg. 2) Posted: Fri Oct 07, 2005 6:35 am
Post subject: Re: Can't connect to AS 2005 cubes [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
That's odd. I'm using Excell 2003 on a workstion with Sept CTP client
as well. The cube I'm trying to connec to only has 2 dimension so
memory shouldn't be an issue. In any case, it doesn't appear to get to
that point. It connects to the server and lets me choose a database
but fails right after that.

 >> Stay informed about: Can't connect to AS 2005 cubes 
Back to top
Login to vote
pcjunk16




Joined: Oct 10, 2005
Posts: 2



(Msg. 3) Posted: Mon Oct 10, 2005 9:19 am
Post subject: Re: Can't connect to AS 2005 cubes [Login to view extended thread Info.]
I'm experiencing exactly the same problem. I've installed SQL 2005 CTP of June (tried more CTP's as well!). In Excel 2003 I want to create a PivotTable using an external Data source. When trying to connect, the cubes are detected, but I cannot get any further.
The error in Excel is: initialization of the data source failed. Check the database server etc...
Also other client tools like Proclarity cannot connect to the Cubes

Can somebody tell me what the problem could be?
 >> Stay informed about: Can't connect to AS 2005 cubes 
Back to top
Login to vote
pcjunk16




Joined: Oct 10, 2005
Posts: 2



(Msg. 4) Posted: Mon Oct 10, 2005 9:46 am
Post subject: Re: Can't connect to AS 2005 cubes [Login to view extended thread Info.]
Ok, it works in Excel now. To solve it you should register msolap90.dll by running this command:
regsvr32 "c:\program files\common files\system\ole db\msolap90.dll"
 >> Stay informed about: Can't connect to AS 2005 cubes 
Back to top
Login to vote
Randy Knight

External


Since: Oct 03, 2005
Posts: 8



(Msg. 5) Posted: Thu Oct 13, 2005 1:52 pm
Post subject: Re: Can't connect to AS 2005 cubes [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Registering the DLL worked for me as well at least in terms of Excel.
I was told by ProClarity that 5.2 can't connect to AS 2005 and I don't
have it on this box since I upgraded to YellowStone (6.1) beta so I
could see my AS 2005 cubes. But it's nice to have Excel working at
least.

Anybody have a released version of ProClarity hiting 2005 cubes?

Also, regarding the comment above regarding the dll being registered
during AS install, the workstation I am on had September CTP installed
on it, including AS. But still had to register the DLL manually.
Maybe a CTP bug?
 >> Stay informed about: Can't connect to AS 2005 cubes 
Back to top
Login to vote
olap

External


Since: May 04, 2005
Posts: 16



(Msg. 6) Posted: Fri Oct 28, 2005 3:41 pm
Post subject: Re: Can't connect to AS 2005 cubes [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi,

Just download the new trial of ReportPortal and you can connect to
AS2005 cubes !

www.gmsbv.nl > order free Cd

Regards, Marco
 >> Stay informed about: Can't connect to AS 2005 cubes 
Back to top
Login to vote
Paul Joubert

External


Since: Nov 20, 2003
Posts: 3



(Msg. 7) Posted: Fri Oct 28, 2005 5:55 pm
Post subject: Re: Can't connect to AS 2005 cubes [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Get the following error connecting from Pivot Tables in Excel to AS 2005:

XML for Analysis parser: The LocaleIdentifier property is not overwritable
and cannot be assigned a new value.

Any ideas?

Regards,
Paul


beta of ProClarity 6.1
"Randy Knight" <knight.randy RemoveThis @gmail.com> wrote in message
news:1128638910.303429.103790@g49g2000cwa.googlegroups.com...
> I've read here and elsewhere that older OLAP clients (such as Excel
> 2003) can connect to AS 2005, but without support for new features. I
> can't seem to get anything to connect to my AS 2005 box. I'm running
> the September CTP on both the server and the workstation I'm trying to
> connect with. The odd thing is it will connect to the server and let
> you pick a database but doesn't go any further than that.
>
> I've installed the beta of ProClarity 6.1 so I can use that but I want
> to use Reporting Services 2000 and can't get that to work. Also tried
> Excel 2003 ... no dice their either.
>
> Anybody else seen this and if so, how did you resolve it?
>
 >> Stay informed about: Can't connect to AS 2005 cubes 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
HOW TO CONNECT 2 CUBES IN EXCEL - I HAVE 2 CUBES: ONE ACTUAL ANOTHER BUDGET. HOW TO CONNECT 2 CUBES INTO ONE SINGLE TABLE/PIVOT TABLE IN EXCEL ?

SQL Server 2005: Process Cubes of a Analysis Server 2000 i.. - hello everybody! i'am having a problem while migrating from sql server 2000 to sql server 2005. i'am still using the dts service in 2005 and haven't migrated the dts packages to ssis. i'am having problems with DTS packages which are using the "Anal...

Cubes are slow sometimes. - Sometimes during the day, the cubes I'm using slow down a lot. A set of querries that usually takes 1-2 seconds will take 50 or 60 seconds. I'm not sure if this has to do with the cache or the way sql server works. What should I look for to see why..

Autoexist in AS 2005 cubes - With Autoexist I thought that AS 2005 would finally work as a relational database "inner join" between dimension tables and fact-tables. My thought was that if I put a customer dimension, with 3000 members, together with a product dimension...

Cubes not available after processing - The problem is that the cube is not available for queries. But process structure has been made, a full process of the dimensions and of the measure groups. This is what I did do: I did Import the SSAS Project from my live server to my local machine ...
   Database Forums (Home) -> OLAP All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]