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.
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.
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?
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.
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.
Report Portal
Cube connection problems
Posted - 07/27/2005 : 20:25:40
