Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Cube connection problems

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
restardo Posted - 07/27/2005 : 20:25:40
I created a user of "OlapAdmin" in SQL Server 2003 and added it in an Analysis Services cube (Foodmart) permission/role. In report portal, I created a new user (e.g. rey) with an NT account of "OlapAdmin".
However, the system cannot connect to a cube when I run an "Olap Report" (blank database and cube).

I already followed the basic setups required but for some reason the user account in report portal is not recognized.

Any ideas how to troubleshoot it?
4   L A T E S T    R E P L I E S    (Newest First)
restardo Posted - 07/28/2005 : 18:02:27
you've resolved my problems.

Here's what I realized:

a) The anonymous user authentication must have Olap Admin role
b) The regular cube users must not belong to Olap Admin role (just users) so you could limit cube access
c) I tried to use the server name as a datasource name but this didn't worked in WS 2003 (only in my laptop). I switched it back to "Local Analysis Server". Everything works well now.

Igor, you the man!
admin Posted - 07/28/2005 : 12:00:47
You don't have to use the "Administrator" account for the
Anonymous authentication. You can use any of the domain users that are part of the "OLAP Administrators" group.
restardo Posted - 07/28/2005 : 10:01:04
I have followed the recommended setup and it worked on my laptop/XP only. Even so, I noticed errors even in the event viewer. It could probably influence the error I am getting using the server.

"Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
Logon account: Administrator
Source Workstation: LIMTRESTAVXP
Error Code: 0xC000006A"

This error occurs as a "Security failure audit" and keeps on generating after a cube connection is successful (e.g. olap report, owc). Is the "Administrator" account manadatory in the "ReportPortal" anonymous authentication (I'm not login as administrator)? Any workarounds?

Thanks
admin Posted - 07/28/2005 : 01:37:32
Please make sure that you have:

1) Enable basic authentication only on the XMLA virtual directory.
2) Enabled: Admin > Settings > Olap Report - XML for Analysis Security Enabled

To troubleshoot try testing the security with XML/A Sample Application

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page