Olap Cube SQL AS 2008

[Jay]

I have a problem ,with building an OLAP Cube from PS2007.

I have a three tiered SharePoint farm.

Server 1 : – Application Server x 64bit

Sever 2: – SQL 2008 sp1 x 64 bit Named instance.( SQL Database engine)

Server 3: – Default instance – Analysis server. SQL 2008 sp1

When I try to build a cube from the Application server I get an error :
Cannot connect to Analysis Server version 10.%$#@.%$.

My work around :

I have installed the following requirements:

1. SQL Native Client 10.0
2. SQL Managed Objects Collection 10.0
3. Backward compatibility v8.%%%% ( Latest version)

But I still receive the same error.

I have gone through every step on the Microsoft whitepapers , through all
Cristhoper Fiessinger`s blogs, no luck what so ever.

I am a bit lost here.

Can someone please help here

 

[Rob Schneider]

best to re-ask on the newsgroup where the Project Server gurus hang out:
microsoft.public.project.server

--rms

www.rmschneider.com

 

[ProjmanZA]

best to re-ask on the newsgroup where the Project Server gurus hang out:
microsoft.public.project.server

--rms

www.rmschneider.com
















- Show quoted text -

Jay ,

I had this problem just last week. The solution is to install the SQL
Client tools on the Application / project Server. Then it should work.
MS also suggest installing OLEdb10 on the client aswell

let me know if it helped

Andre