This is a tough one because it involves a number of elements surrounding
Analysis Services.

On my XP Professional laptop (not part of a network, but i am connected to
internet), I have Analysis Services Enterprise Edition installed along with
SQL Server 2000 and Excel 2003.

I am configured for http access to Analysis Services (msolap.asp resides in
my wwwroot folder). I have confirmed that I can connect to cubes via http
(using OWC 10.0 and also Excel's OLAP Pivot Table wizard)

However, I'm having trouble getting my cube roles working. I have created a
cube role to manage access to a particualar cube. The role includes a
single XP user that I created specifically for this test. If I test the
cube role from within Analysis Services, it works fine. No surprise there.

The problem arises when I attempt to build an Excel OLAP pivot table against
the cube via http. It seems that unless the user "Everyone" is a member of
the cube role, the cube of interest does not show up in my list of available
cubes within the Excel Pivot Table wizard.

How can I create an XP user (who has a password) and assign him, and only
him, to a cube role which has limited access to a cube, and then
successfully log on as that user in the Excel Pivot Table wizard, and be
granted the appropriate limited permission to that cube?

Thanks!