The ImpersonationInfo for datasource contains an ImpersonationMode that can only be used by a server administrator

Question

Hi All,

We have created a new SSAS 2008 R2 DB and we are trying to run the XMLA of DEV Server into Integration Server (new DB).

We have been given Full Control (Administrator) on the new DB (DB level).

I am trying to run a ALTER Command (XMLA) at the DB Level and we are getting the below issue:

"The ImpersonationInfo for datasource contains an ImpersonationMode that can only be used by a server administrator"

Any help is much appreciated !!

Thanks,

Swapnil

Answer 1

Hello,

Follow the links below for more help.

http://support.microsoft.com/kb/922853

http://blogs.msdn.com/b/john_daskalakis/archive/2009/12/16/9937631.aspx

Answer 2

Hi Swapnil,

To solve the issue, go to SQL Server Management Studio and connect Analysis Services service, right click on the Analysis Services Instance and select Properties, in the Properties window, click "Security" and add the user used to execute the XMLA statement to the Server administrators.

Regards,
Jerry

Answer 3

Hi Jerry,

Since we do not have Server properties and we do not have policies to give developer user the properties to change the Impersonation Mode, we are facing this issue.

A work around for this is that the same user if he tries with the AS Deployment Utility instead of the XMLA and specifying the Roles (Retain Roles and Members. The roles and members will not be deployed).

This way the developer can deploy the structure from one DB to another without having the permissions to execute XMLA Statement.

Cheers!!

Swapnil