I am trying to setup access to a MSAS 2005 cube with PowerPlay 7.4.
I have managed to setup a mdc file that points to the MS cube. If I browse the cube in the PowerPlay portal I get prompted for a login (cognos login page). I then enter my windows account and get access to the cube. If I try to enter a different windows account (that also has read access to the cube on the msas side) I get thrown back to the login page again without any error messages.
I have activated the powerplay logs and get this error message in the log file:
==== ppdsplOpen(Finance)
*I* Account priveleges:
=======================
SeTcbPrivilege Agera som del av operativsystemet
==========================================================
*I* Impersonate as "lisand" in domain "knowit"
>>> CPPDSPLConnect
*I* Setting up a DBPROMPT_NOPROMPT option in SERVER mode
*E* in File: .\ppdsplcn.cpp on line 1507:
"m_pIDBProperties->SetProperties( iSet , rgPropertySet)"
*E* CPPDSPLConnect: Failed to connect to the specified server: HRESULT 80004005
*I* (1) status 146
If I try my personal account (that works fine) I get this log:
==== ppdsplOpen(Finance)
*I* Account priveleges:
=======================
SeTcbPrivilege Agera som del av operativsystemet
==========================================================
*I* Impersonate as "bjolid" in domain "knowit"
>>> CPPDSPLConnect
*I* Setting up a DBPROMPT_NOPROMPT option in SERVER mode
*I* Connection Information c1 REMOTE CUBE
===============================
Server Name: plattan03
Provider Name: MSOLAP
Database Type: MS SSOS ODBO
Catalog Name: Finance
Cube Name: Finance
Create Cube:
Insert Into:
DSN Source:
===============================
========================================================================================
Remote OLAP Server Name : Analysis Server
Remote OLAP Server Version : 9.00.1399.06
Local OLE DB Provider Name : Microsoft OLE DB Provider for Analysis Services 9.0
Local OLE DB Provider File Name : msolap90.dll
Local OLE DB Provider Version : 9.00.3042.00
Local OLE DB Provider Compliant Version: 02.60
Maximum Active Session Allowed : No Limit
========================================================================================
Why can I not access the cube with a different windows account?