Problem with OLAP roles from asp.net

[viking2020]

Hello
I am new to OLAP. I am using Analysis services 2000 Enterprise version.I am trying to access a cube from ASP.NET. I created some roles on the cubes and they work fine in analysis server. When i access the cube from asp.net it works fine with anonymous access which uses IUSR_Machinename account. I added new roles to the cube and associated the roles with username present on the same domain as the Analysis server. For basic authentication sent the username and password in the connection string and used integrated windows authentication but when authentication is used the Pivot control shows all data irrespective of the roles in the cube . it does not restrict data according to the role. I guess the problem is that the analysis server is not able retrieve the current user role.

What are the requirements for the user account on the server that is to be associated with the database roles in Analysis server. I have my account as administrator and olap administrator.


Any help or suggestions are appreciated

Thanks
Balaji

 

[MDXer]

for roles to work you need to run under NT Authentication. You can write an ISAPI Filter that takes a basic Auth and does an NT Auth at the same time.


"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck