Hi

have a slightly complex issue and would like to know if there is a solution:

I have a COM DLL querying AS2K cubes using ADOMD (built in VB6). Each time
the queries fire off, the cube connection is supplied with the user name,
password, catalog and server (all running on the internal network though
TCP/IP).

I have then created a Vb.NET service that calls the DLL to fire off the
queries at regular intrevals. The service is run under a network super user
ID - with full OLAP admin access. The service and cubes are not on the same
machine.

The problem is in the application of cube security: each query may have a
different user Id with different levels of cube access. But, when the
queries run, it seems that the security on the ADOMD connection is ignored.

What am I missing? Is there a way to avoid this issue? Should I try to use
the LogonUser API somehow? Would it work if I instead went against the cubes
via (internal) HTTP ?

Any ideas

thanks
Avi