Cannot access cuble when user is not OLAP admin

[Shab]

Hi,
When I try to use OLAP server that is with SQL server sitting on a computer on network, with my VB application, I get an error if my user is not part of OLAP admin group. This happens even if I have the right read/write roles assigned to me. Is there a workaround? If somebody know please let me know.
I cannot leavethe user as OLAP server admin.
Thanks

 

[aalmeida]

From BOL:
User Accounts and Groups
Before you create roles in Microsoft® SQL Server™ 2000 Analysis Services, you must create user accounts and groups in User Manager in Microsoft Windows NT® 4.0 (or Computer Management in Windows® 2000). To be created, a role must contain at least one user account or group. A user account or group cannot be added to a role until after it is created in Windows NT 4.0 or Windows 2000.

It is usually best to finalize and implement a design for the memberships of groups before you create roles in Analysis Services. This approach can reduce the amount of required role maintenance.

If you are using NTLM Security Support Provider as your authentication method, all user accounts and groups that are to be granted access to cubes on an Analysis server must be in the same domain as the user account under which the Analysis server was installed or in a trusted domain. User accounts and groups in other domains cannot connect to the Analysis server.


To know more about these you can read the following articles from BOL "Operational Considerations", "Administrator Security"
Those may put some light over the issue
AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[Shab]

Thnak you!
I checked the network confih again. Looks like people log in in their own machines rather than domain, but because they have the same user name and password on domain too, the domain lets them access resources.
I changed the cube access mode to Everybody and it worked. Also if I create a local user on SQL server machine for user, and grant permisiions for that user to access the cube it works.
This solved my problem for now. Later we will swicth everybody to domain.
Thank you for your help.