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 InformationSI 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
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 InformationSI 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