November 20, 2006 at 8:27 am
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.
I am running both the sql serivce and SSAS service using the same service account, and this account has db owner privileges on the database in quetstion.
anyone have any ideas?
November 23, 2006 at 8:00 am
This was removed by the editor as SPAM
January 15, 2008 at 5:19 pm
I did get the same error, but when I changed the impersonation info to "default" mine worked...
April 10, 2008 at 1:36 am
This also worked for me.
April 11, 2008 at 9:49 am
I see this type of problem multiple times, so I thought a bit of an explanaton would help.
You have to remember that Visual Studio and MSAS are separate processes and hence can end up with separate authentication schemes. This is particularily apparent for anyone using 64 bit, in particular with a third party driver like Oracle. (VS uses 32 bit, MSAS uses the 64 bit).
When you're attempting to do things like impersonation, you have to remember that from VS, you're using your credentials and when MSAS runs, it's using it's credentials. So rights in the domain matter.
When you're "testing" the connection, you're testing from a VS perspective. That doesn't necessarily mean MSAS connects. It should if MSAS is using the same connection scheme, 32 vs 64, same initial ID, etc.
Default works in most (many) cases, since it simply uses the connection string, and doesn't try to do any impersonation.
Hopes this helps.
October 11, 2009 at 11:00 am
I'm still struggling with this, despite trying all the options;
In the Server Explorer, the connection uses Windows Authentication.
In the Analysis Services Project database tab, Properties, I have tried:
1) Use the Service Account
2) Use the credentials of the current user
3) Default
When trying to deploy (using Build, Deploy Analysis Services Project), all generate the following messages;
Error1Internal error: The operation terminated unsuccessfully.00
Error2Internal error: The operation terminated unsuccessfully.00
Error3The datasource , 'Adventure Works DW', contains an ImpersonationMode that is not supported for processing operations.00
Error4Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'Adventure Works DW'.00
Error5Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Department Group', Name of 'Dim Department Group' was being processed.00
Error6Errors in the OLAP storage engine: An error occurred while the 'Department Group Name' attribute of the 'Dim Department Group' dimension from the 'Analysis Services Project1' database was being processed.00
Error7Server: The operation has been cancelled.00
Any ideas anyone, please!?
RW
October 11, 2009 at 11:09 am
...And I should have said, this is all on the local machine.
RW
October 14, 2009 at 1:23 pm
Are you running x64? If so, make sure you have both the 64 and 32 bit drivers installed. Otherwise, let's step through this:
a) check to make sure you can browse the data via the project.
b) change the project options to "Do Not Process" and test the deployment to MSAS separately.
c) Once deployed, do a test process. Start up SQL Profiler and make sure you see the connection to the server.
October 15, 2009 at 12:50 am
Thanks Dave,
Whilst plucking up courage to try your solution, I found that by right-clicking in the Solution Explorer I got another option to change the Impersonation Mode. When I selected 'Default' here (I had already done this on the toolbar with the Database tab active), the deployment succeeded.
But your suggestions are noted for future use.
Thanks again
Roger:-)
October 15, 2009 at 5:42 am
I see the confusion (I think). Yes, everything about your project in MSAS is in or accessable from the "Solution Explorer" tab. Specifically in your case, you needed to get to was your "Data Source" and set the impersonation mode.
I couldn't find the "Database tab" you refered to.
Cheers and happy MDXing!
June 16, 2011 at 8:25 am
Apologies in advance for posting to a two year old topic, but I just went through the same rigamarole, and couldn't find the "right" place to change the impersonation mode. When selecting the project in Solution Explorer, deployment was set to "default" (Configuration properties, highlight Deployment, "Default" shows up on right). Even under Configuration Manager, Default was selected. However, by double-clicking the data source itself, the Data Source Designer showed up, with a tab for Impersonation Information, where I could change the setting from Service Account to Default. None of this information was available under Properties of the data source.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply