dbTalk Databases Forums  

Error connect Excel to OLAP cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Error connect Excel to OLAP cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris
 
Posts: n/a

Default Error connect Excel to OLAP cube - 09-14-2006 , 03:53 PM






Hi,
I am trying to connect Excel to OLAP Server Cube but I am getting the error

Initialization of the data source failed.

Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again.
If you see this message again, create a new datasource to connect to the
database.

This is how I am connecting. I am using Office 2003. From new database Query
I select the tab "OLAP CUBES". then "New Connection" and "OK". I gave it a
name, and select OLEDB PROVIDER FOR OLAP SERVICES 8.0, then "CONNECT". I
entered my server name "SERVER" and selected the database I want to work with
and click finish. I then select the cube I name I want and click "OK". When I
try to now connect to the cube I get the error above. Any ideas?

Thanks


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.