OLAP Cube

[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.

 

[Gary Chefetz]

Jay:

It's really helpful to post the exact error and anything you can dig up from
the ULS logs. In the meantime, have a look at the following and see if that
helps. Otherwise, give us some more to go on.

http://blogs.msdn.com/brismith/arch...ilding-gotcha-is-your-alias-32-or-64-bit.aspx

 

[Ben Howard]

Hi Jay, i've found that the documentation for installing the feature pack
details the wrong feature pack. Check out my blog here for the details.
This has happened to me on more than one occassion....
http://appleparkltd.spaces.live.com/blog/cns!EB0688A7A6F04E1D!786.entry
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

 

[Jay]

Hi There

Thank you very much for your replies.

Here is the failure message:

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to connect to the Analysis Services server Owl.
Error: Cannot connect to Analysis Services version '10.0.2531.0'.

Event Viewer:

SSP Name: SharedServices1
PSError: CBSASConnectionFailure (17003)
Cube build failed to connect to the Analysis Services server. Verify the
data source connection is valid. Error: Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=Owl ASDBName=EPM_Cube1
ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0
FromDate=10/13/2009 09:21:35 ToDate=10/13/2009 09:21:35 HighPriority=True.

Regards
Jay

 

[Gary Chefetz]

Jay:

Based on the error, I'd say that Ben is pointing you in the correct
direction. The other possible cause is incorrect service account
permissions.

 

[Jay]

Hi Guys.

Firstly thank you Gary and Ben.

Secondly. I have applied the updates in order as indicated in the blogs.
Still no luck.

The only solution currently is that we install , Analysis Services on the
Application server. This will emulate a single server installation.

Regards
Jay

 

[Ben Howard]

Hi Jay,

Cannot connect... Is the browser service running?

Also, installing AS on the app server doesn't fully emulate a single server,
presumably your SQL is elsewhere. However, it does tend to work 1st time.
Do let us know how you get on
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/