If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Problem accessing MS cube using different windows accounts

Started by globalbear, 07 Apr 2009 04:34:51 AM

Previous topic - Next topic

globalbear

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?