Hi Mosha,

I have installed Yukon (SQL Server 2005 Beta 2, April 2005 CTP) on a
new high-spec XP (SP2) notebook along with MS Office 2003.

Yukon works ok. I have built and populated a simple Analysis Services
Cube. I have created a ROLE in A/S and granted the Administrator user
access to the Cube and checked the "Enable Read Permissions" box in the
Cube Cell Data option.

But, when I try to access the Cube via Excel 2003 (SP1) using the
Import External Data -> New Database Query -> OLAP Cube option, I can
select the Server & Cube but when I click Finish I get:-

Initialisation of the Data Source Failed
Check the database server or contact your DBA etc.

I have checked that I can browse the Cube via SQL Server Management
Studio and I have set-up the A/S ROLE as stated in the "Guidelines for
setting permissions" documentation.

So, do you know why I am getting this error in Excel?

Thanks.

Regards,

Andrew