Very Computer

Hello,

I've been running some olap applications for a while and everything
seems to be working quite well. The server is a w2k machine with sql
server 2000 (not enterprise edition).

My problem is that whe're switching to XP on the server and all of a
sudden the cubes are unavailable for my applications. After studying
some discussions I found out that:

1. on a w2k server the anonymous logon is mapped to the NT
AUTHORITY\ANONYMOUS LOGON user wich is a member of the global everyone
group.

2. That does not apply on a server running XP.

I've tried to assign various users and groups in the cube roles, but
none of the available ones seems to be working.

The connect string I'm using looks something like this:
Data Source=myserver;Initial Catalog=my catalog; Provider=msolap;
SSPI=anonymous; MDX Compatibility=2;

So the question is if there is anyone who has an idea how to deal with
this?

regards
/Niklas

Quote:> Hello,

> My problem is that whe're switching to XP on the server and all of a
> sudden the cubes are unavailable for my applications. After studying
> some discussions I found out that:

> 1. on a w2k server the anonymous logon is mapped to the NT
> AUTHORITY\ANONYMOUS LOGON user wich is a member of the global everyone
> group.

> 2. That does not apply on a server running XP.

> So the question is if there is anyone who has an idea how to deal with
> this?

Niklas, I beleive that in Windows XP, it is still mapped to NT
AUTHORITY\ANONYMOUS LOGON, but in Windows XP by default this account is not
member of the Everyone group. You either need to explicitly add it to you
role, or you can tweak registry to force it to be part of Everyone group:

Anonymous tokens do not include the Everyone Group SID unless the system
default has been overridden by setting the
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\EveryoneIncludesAnon
ymous registry value to DWORD=1.

--
==================================================
Mosha Pasumansky (moshap at microsoft dot com)
Development Lead in the Microsoft Analysis Server team
More info at http://www.mosha.com/msolap
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================