Anyone getting error while trying to create a OLAP connection to SSAS 2005
via Crystal Report XI.
I need help. This is the error message that I get.

The connection could not be established:
Failed to set properties (The following system error occured: The requested
opertaion requires delegation to be enabled on the machine. .)

I have no problem creating the OLAP connection via Excel's PivotTable.

Thanks.

Try leaving the ID and password blank when creating the connection to SSAS.

--
Dean Adam
Magenic Technologies


"See Lim" wrote:

It work, but who am I logging on as? Window NT User, SQL User...?
I want to pass in user credential to SSAS for data segegration.

Thanks in advance.

"Dean Adam" <DeanAdam (AT) discussions (DOT) microsoft.com> wrote

It is authenticating to SSAS using your Windows credentials. Is that what
you want?
--
Dean Adam
Magenic Technologies


"See Lim" wrote:

Yes, but it doesn't seems to be taking my window credentials.
I don't know what I'm doing wrong.

"Dean Adam" <DeanAdam (AT) discussions (DOT) microsoft.com> wrote

If your problem is that you can see too much data, i.e. your security roles
are not being applied, remember that members of the OLAP Administrators group
always see all data, regardless of AS roles.

To check which credentials are being used to connect to Analysis Services,
edit the cube and add a calculated member to the measures. For the MDX
expression, just use the single word:

USERNAME

This will return the ID of the user connecting to the cube, in the form
DOMAIN\USER. Add this new measure to your report so you can confirm the ID
that is connecting to the cube.

--
Dean Adam
Magenic Technologies


"See Lim" wrote: