I've followed an example in a book and created my first cube and deployed it on my local laptop. I can browse the cube in BIDS and drop dimensions and measures into the browser to see results. the SQL Server Analysis service is running on my laptop and is the database engineand SQL Server agent.
I have tried to access the same cube via Crystal Reports 10.
I specify the server type as 'Microsoft OLEDB Providor for analysis Services 9.0' and set the OLAP Server to my laptop IP address.
I get the error message, 'The connection could not be established. Failed to set properties ( The following system error occurred: The requested operation requires delgation to be enabled on the machine )'.
Anybody any idea what the problem is?
Dazed and confused
I have tried to access the same cube via Crystal Reports 10.
I specify the server type as 'Microsoft OLEDB Providor for analysis Services 9.0' and set the OLAP Server to my laptop IP address.
I get the error message, 'The connection could not be established. Failed to set properties ( The following system error occurred: The requested operation requires delgation to be enabled on the machine )'.
Anybody any idea what the problem is?
Dazed and confused