winstonSmith


I get the below error when i try to process my cubes:

The datasource , 'local - SRDB', contains an ImpersonationMode that that is not supported for processing operations.

I have tried all 4 impersonation modes, but the same error comes from all. i created a new connection , and when i click "test" it says test successful, but the new connection throws the same error. anyone have any ideas




Re: The datasource , 'db name', contains an ImpersonationMode that that is not supported for processing operations.

Dave Fackler


What type of data source are you using As you probably know, creating and testing a data source within BIDS is not quite the same as setting the impersonation mode for the data source. The credentials specified by the impersonation mode are only used when the SSAS engine needs to connect to the data source (to process things, for example). Within BIDS, the designers use whatever connection credentials are specified when the data source is created (which is what the Test Connection button tests).

Dave Fackler






Re: The datasource , 'db name', contains an ImpersonationMode that that is not supported for processing operations.

Thomas Ivarsson

Is your data source on another server

If so, your problem can be related to the account that you use for the SSAS2005 service. Use the same domain account for access rights to the data source and that you are using for the SSAS2005 service.

HTH

Thomas Ivarsson






Re: The datasource , 'db name', contains an ImpersonationMode that that is not supported for processing operations.

winstonSmith

im testing it on my own machine. the database its connecting to is on the localhost. the account that SSAS is running under has been granted full access to the database in question. I have tested my  connection and the test succeeds, yet still get the same error when processing.



Re: The datasource , 'db name', contains an ImpersonationMode that that is not supported for processing operations.

Nyaroh

I have tried the following :

My MSAS 2005 service runs on machineA under a local admin account '.\sql05svc'. I have recreated the same account on machine b (which hosts the database that I want to create the cube for ) and added it to the Admisnitrators group. The cube gets processed just fine now.

Hope that helps

~R





Re: The datasource , 'db name', contains an ImpersonationMode that that is not supported for processing operations.

Mike C

the problem being desicribed included both the analysis server and sql server funning on the same local box . If i can view tables through the datas ource view, i would think i can process dimensions based on those tables.



Re: The datasource , 'db name', contains an ImpersonationMode that that is not supported for processing operations.

FLA01

Perhaps you have already solved your problem. If don't, try these steps:
1. Create a role in the database you want the cubes to get processed
2. Assign this role permission to process database
3. Add a valid domain\username and password to this role
4. Set the previous domain\username and password for the ImpernationMode