Error while building CUBE

B

Buhari

I am getting an error while i was building cube in Project server 2007.

The error details:
PWA Log
"Failed to build the OLAP cubes. Error: Analysis Services session failed
with the following error: Failed to connect to the Analysis Services server
NJ06NT035. Error: Authentication failed. "
App Server log:
"Standard Information:pSI Entry Point:
Project User: GLOBAL\SVSMPPSSetup
Correlation Id: 28fc4631-36d0-4424-a6d5-f994bd1c5a32
PWA Site URL: http://nj06nt041/tPWA
SSP Name: SharedServices1_SMPS
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=NJ06NT035
ASDBName=NJ41_ProjectServer_Analysis ASExtraNetAddress=NJ06NT035
RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=03/21/2008
11:25:15 ToDate=03/21/2008 11:25:15 HighPriority=True"

I have SSP account as admin in AS 2005 and SQL server 2005.

Can anyone help me ?

Thanks,
Buhari
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top