I have a .NET site that is server 'A'. I have the Analysis Server and my cubes built on server 'B'.

I need to access the DSO so I can list my built cubes on the site, but I need the ASPNET user from server 'A' to be in the OLAP Administrators group on server 'B'. That's proven impossible.

How can I give my ASP.NET site access to the DSO object?